Functions

Invisible Column names and Row numbers
Friends, I received a work sheet from my friend which has data from a1 to m60. But surprisingly after the column M, whole letters are invisible and same in the numbers after 60 it is invisible, like sealed with a color pack. How do I see number 61 onwards and column M onwards N O P etc etc .. Please as... 28 May 2010 17:05

how to compare the old code and new code?
I have old code and old description in my excel. Now company given me new code with same description. I want to compare the old code with new code but description is same. how to compare? regards, pradeep.K ... 28 May 2010 17:05

Calculating date/time intervals??
I have multiple sets of date/time value combinations. For each start time (date/time) and finish time (date/time), I need a formula that calculates the number of days, hours, and minutes between the two events. Example: Start 5/14/2010, 11:25 Finish 5/17/2010, 18:30 Thanks for any assistance! John ... 28 May 2010 20:23

Final Reminder - Microsoft Responds to the Evolution of Community
Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of Office. Office 2010 is all about making it easy for you to get and use Office on your terms. Office 2010 lets you work from the office, from home, or at s... 28 May 2010 12:40

Format Date
Hi, all, How do I format the date to show May, 2010? The closest I can get is May-10 from the drop down list. Thanks, Malcolm ... 28 May 2010 14:53

Formula Help
I would like to remove every character up to the "_" and retrieve the name to the right. Can someone please help me with a formulat that would work for me. 00232902_Joe Smith Thanks ... 28 May 2010 13:46

Interpolation?
What fx to use for the following scenario: Month-End Dates (for many years) in column A A dollar Amount for each Quarter End in Column B (correlating to the month-end date). We would like a function to easily copy down column B that will interpolate values in between the dollar amounts for each quarter end. ... 1 Jun 2010 11:59

Linking to external files
I am trying to use and external link that is updated each week based on a week numbered file as below =VLOOKUP(E3,'G:\Mike\In progress\Sameday Product Analysis\[Sameday Database 2010 Values Week 19.xls]Database'!$E:$BH,$M$3+2,FALSE) Is it possible to use a reference to another cell to change the week number. ... 28 May 2010 11:34

Get column headings to float when scrolling down?
How do I get the first three or four lines where I have typed in my column headings to "float" down as I'm entering information in the lines below? ... 28 May 2010 11:34

Averaging a column that contains text
On my worksheet I have a column of12 cells that I need to average. Unfortunately cell B6 contains text (see below). As shown the dreaded #DIV/0! displays in cell B13 until any rates are inputted into the column. After inputting the first rate the formula works great. I'm using the formula; =AVERAGE(B1:B12). Is... 28 May 2010 11:34