| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the most frequent date
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a date in a list | Excel Discussion (Misc queries) | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| how can i find a specific date of a database | Excel Discussion (Misc queries) | |||
| search for latest date | Excel Worksheet Functions | |||
| find date in Col A corresponding to min value in Col B | Excel Worksheet Functions | |||
Threaded Mode
