View Single Post
  #1   Report Post  
Cap
 
Posts: n/a
Default Display row numbers of a range

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