in A1 =column(D2) would return the number 5. I want the reverse of that. e.g.a function that would when pointed at A1, returns the text "D" This beast does...

I am looking to add more items to a IF statement. The current is:=IF('Week 2'!$E$20="Annual","A",IF('Week 2'!$E$20="Sick","S",IF('Week...

Hi group Win XP MS Office 2003 I use a spreadsheet to record players bowls drives scores, and wish to flag up the best 25 scores for each player, from the...

A good day ! I have this function : =AND(COUNT(B1;B3;B5)=1;COUNT(C1;C3;C3)=1;COUNT(D1;D3;D5)=1;COUNT(E1;E3;E5)=1;COUNT(F1;F3;F5)=1) ; this function...

I am attempting to create age ranges using the COUNTIFS formula. However, the numbers that is gives back to me are wrong. The formula:...

I have been told to use Special Paste, here is what I have been told The paste special command is a very useful command which you should add to your...

I start with a list like this company carries 101 INDUSTRIES BRASS LIGHTING...

I have the following text string in cell A1. Flight Schedule - Friday 28th November 2008. How can I extract the date from the text string and paste it in...

I have raw data that downloads in 2 different formats. 451 22:07:34 (451 = # days a problem is not resolved) 3:39:10 (hrs, minutes, seconds) I need a formula...

I would like to create a table that is 16 rows deep and 16 columns across where the numbers 1:16 are in the cells in column a. Then going across I need each...

Hi All, I have two dynamic named ranges: "Data" and "Refs", each spanning 10 columns and the same number of rows. They both hold numeric values. Using input...

How would I do the following: A+B = C, if C = 10 then D = 1 if C = 11 then D = 2 C = 12 then D = 3 and so on C = 19 then D = 1 thank...

I have 8 check boxes in Excel on rows 1:4 and 6:9. I have other macros that hide and unhide these rows together or separately. When all rows are hidden and...

I have a sheet, with each row containing one record. Column A contains a date, and column B contains a department. The contents of the column A (date) are...

Hello, I have an Excel 2003 file with 8 columns that one could filter on. The AutoFilter function is set to ON. I have found that the users do not always...

Within one workbook, I'm trying to have one tab read off another using a formula. I need the "Summary" tab to display the last cell with data (not null) in a...

I'm posting this again... For those using Excel 2003, there is a bug in the SLOPE/INTERCEPT formulas. If a y data point is deleted at the first or last...

Hello How to print formulas and their results on the same page? The "Formula Auditing mode" prints only formulas without their results.

Various members of this forum have stated that the arrays used in SUMPRODUCT must be the same. Excel HELP says, under remarks, in part..."Array arguments must...

Both COUNTBLANK and ISBLANK relate to empty cells. Yet I have a spread sheet that provides the following seemingly contradictory results: * The calculated...