I am not sure how to obtain the row number from the first date (selected by reference to a separate report sheet) in a column of dates and the row number of the last date (also selected in the seperate report sheet) also in the same column of dates.
e.g.
Col A = Dates
R1 01/04/11
R2 01/04/11
R3 01/05/11
R4 01/06/11
R5 30/06/11
R6 30/06/11
So, if I needed the Row number of 01/04/11 and 30/06/11 it would need to be Rows R1 and R6, not R2 and R5
Can anyone help please?
Bookmarks