Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I'm trying to find the 6th latest unique date in a list of dates: 5/25/2006 5/26/2006 5/30/2006 5/30/2006 5/30/2006 5/30/2006 5/31/2006 6/1/2006 6/2/2006 6/3/2006 6/4/2006 So, I want the formula to return 6/2/2006, but using the large function returns 5/30/2006. Is there a way to count 5/30/2006 only once instead of 4 times. I really need to be able to do this in a single cell formula. Thanks, Brett |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
counting unique entries in a list | Excel Discussion (Misc queries) | |||
unique occurences in list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
select unique to make list | Excel Worksheet Functions |