software

My vlookup formula no longer works, I think it may be something to do with
the fact that the data is no longer in sequential order e.g. 1, 2, 6, 5 and

David Gainer (Group Program manager for Microsoft Excel 12) has posted a

I have dates entered like 20051214. How do I format them so that Excel will
recognize as a date?Select the column with dates, go to Data/Text to Columns...select Fixed Width

Is there a quicker way to select columns to include subtotals in? I have a
spreadsheet with 50 columns. Clicking each one individually is tedious.

I have data in several columns and I would like to combine values in all

Hi, Please help. I am trying to get Excel to calculate the following.
A1 = 11.8% A2 = 12.8% A3 = 11.67%

Hello all. I'm hoping for a really simple answer. Ok, here goes.

This might not be the right area however i am a newbie to Excel so i

i am getting an error when trying to hyperlink from one page in a workbook to
another page in the same workbook. the error simply states that quot;cannot open

How would I use a value from another cell as part of a variable in this