Assuming your data is in A1:A16, then for the first use:
=MATCH(A1,$A$1:$A$16,0)
and last
=MATCH(A1,$A$1:$A$16,1)

Note that this returns the position with respect to the array selected.
Please adjust the value by adding the rows to each formula if you are not
starting at top. For e.g. your start from A2, then add 1 to both formulae.

Mangesh



"choice" wrote in message
...
in row A i have dates (multiple, but ascending)
i need to find the row that first contains a date and the last row that
contains that same date

thanks in advance