View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daikontim
 
Posts: n/a
Default Returning value next to the nth occurrence of a particular number.

Hi,
I have 2 columns. Column A has numbers, some of which are repeated
numerous times. Column B has dates. How do I look up the nth occurrence
of a particular number in column A and return the corresponding date? Any
help greatly appreciated.