First row (formula in J1):
=MATCH(B1,D:D,0)
Last row:
K1: =J1+COUNTIF(D:D,B1)-1
HTH
Jason
Atlanta, GA
-----Original Message-----
I'd like to be able return the the row numbers (started
at
row - ends at row) from a list of names that are in D2
to
the end possibly. The list will always be sorted!
(E.g. In B2 I'd like to type in Joe; and in Column D Joe
is found starting at row 371 and the last row with Joe
is
806. It does not matter if two cells are needed to show
the two numbers.)
I'm not sure how to do this!
TIA
.
|