| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row Number
I need hellp with a formula.
In Cell E8 I need to write a formula that will search Column A rows 18 thru 32 and if it finds the date 09/16/2006 it will display the row number. Any help will be greatly appreciated. Thanks Dianne |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Row Number
You didn't say what result you want if the date is not present.
One way... A1 = some date =IF(COUNTIF(A18:A32,A1),INDEX(ROW(A18:A32),MATCH(A 1,A18:A32,0)),"") If the date isn't present the formula returns blank. -- Biff Microsoft Excel MVP "Dianne" wrote in message ... I need hellp with a formula. In Cell E8 I need to write a formula that will search Column A rows 18 thru 32 and if it finds the date 09/16/2006 it will display the row number. Any help will be greatly appreciated. Thanks Dianne |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Row Number
=MATCH(DATEVALUE("9/16/2006"),A18:A32)+17
-- Gary''s Student - gsnu200909 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Row Number
One more, an array entered** formula (it reports the row number of the last
matching cell in the range if there are more than one match and if reports 0 if there are no matches)... =MAX(ROW(A18:A32)*(A18:A32=--"9/16/2009")) ** Commit the formula using Ctrl+Shift+Enter, not just enter by itself. -- Rick (MVP - Excel) "Dianne" wrote in message ... I need hellp with a formula. In Cell E8 I need to write a formula that will search Column A rows 18 thru 32 and if it finds the date 09/16/2006 it will display the row number. Any help will be greatly appreciated. Thanks Dianne |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Row Number
I used the wrong year (from what you posted) in the date in my formula; the
correction is simple... =MAX(ROW(A18:A32)*(A18:A32=--"9/16/2006")) Note: Commit the formula using Ctrl+Shift+Enter, not just enter by itself. -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... One more, an array entered** formula (it reports the row number of the last matching cell in the range if there are more than one match and if reports 0 if there are no matches)... c ** Commit the formula using Ctrl+Shift+Enter, not just enter by itself. -- Rick (MVP - Excel) "Dianne" wrote in message ... I need hellp with a formula. In Cell E8 I need to write a formula that will search Column A rows 18 thru 32 and if it finds the date 09/16/2006 it will display the row number. Any help will be greatly appreciated. Thanks Dianne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? | Excel Discussion (Misc queries) | |||
| How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
| Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Linear Mode
