Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with formula
Is there any way to do this.
I have a column of dates. The dates are at regular weekly intervals starting from 1990 until now and they are always a Friday. In a separate worksheet I would like a formula in a cell to return the row number of the first date that appears for 1990. Another cell will have the row number of the first date that appears for 1991 and so on for all years up to now. Could anybody suggest an appropriate formula. Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |