I have a work sheet with 6 columns the headers of the columns are A=Class
Codes,B-F are years 2008,2007,2006etc. can i have excell put a value in a
cell as to the column number for the years example for 2008 column 2 for 2007
column 3 and so on.

I have a excel spreadsheet with 2 sheets.
I'm trying to do a vlookup on one sheet and return a value.
The problem is, I need the vlookup to match more than 1 cell.
This is what I want to do:

There is an option of "Distributed(Indent)" for Format Cells/Alignment.
I experimented but it did exactly the same as "Center".  Does anyone
know what else "Distributed(Indent)" can do other than centering?

I have a set of data which has been generated by a DAQ card, which is
essentially a 50Hz sine wave, I was sampling at 1KHz, so I have
exactly 20 data points per period.
My frequency & phase are constant but my amplitude and duty cycle are

I would like a macro to do the following:
I would place the the cursor in any cell and this macro would give me the
average of all the entries to the left if the selected cell. EX: I place the
cursor in cell M12.

I have a huge spreadsheet (that started as a text file) that I am
trying to edit for two conditions separately:
1)  How do I delete entire rows having the text "Jackpot" among its
contents.

I don't know why my excel 2003 new worksheet cannot auto calulate
formula (eg. summation), i need to press F9 and it will refresh and
show the new figure. there is "calculate" word at the left hand bottom
of the screen.

Below email was posted before. I have lost the link that direct me to the
add-in manager that can unhide hidden name.
Can anyone advise me again.
TQ

If given MTBF and standard deviation can the reliabilty be predicted at a
defined operational range using Excels Normaldistribution?
say mtbf = 50, sd= 20, then plug in the operating duration.
NORMDIST(operating duration, 50, 20, true).