Help with formula

[Guest]

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.

 

[Guest]

Ben,

On each row of Sheet1 with your dates put the row number. The =ROW()
function will do nicely.

For the rest of this I'll assume that your dates are in Sheet1 column A
and the row numbers are in column B.

On Sheet2 in column A create a list of years, 1990 through 2005.

In column B, create the first day of each year along the lines of this
formula
=DATE(A2,1,1), copying the formula down alongside your list of years.

Then in Sheet2 column C use the VLOOKUP function to lookup the row
numbers from Sheet1. It should look something like this.

=VLOOKUP(B2,'Sheet1'A:B,2,TRUE)

 

[Ben]

That's perfect. Thanks for your help