View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
choice[_2_] choice[_2_] is offline
external usenet poster
 
Posts: 84
Default what row a value is in?

in column A there are dates (not unique). basically all transaction of a
certain date, so the number of times a date will be there varies

How can i find what row the first instance of a given date appears
i will also need the last row that date appears
(2 seperate equations)

Thanks in advance