View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MarkN
 
Posts: n/a
Default Find the most frequent date

I have solved the above problem.
--
Thanks,
MarkN


"MarkN" wrote:

Hello,

I have a list where column A is numbers. Each number occurs many times in
the list. Column B contains dates corresponding to the number in column A.

20 1/1/01
20 1/1/01
20 3/5/04

Once the list is sorted by number, I need to find that number's most
frequently occurring date. In the example above, number 20 would return
1/1/01.

--
Thanks in advance,
MarkN