Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique count and date associated
Afternoon, I understand the unique count and its working for me I am getting a result list of unique customers, but now I need to get the unique date associated to that unique customer Basically all I want is the date associated to the first time this customer called us and display it next to the result of my unique customer list. Any suggestions? Thanks in advance -- Nelson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique count and date associated
use the DMIN() function the first parameter is your entire table of data. your criteria will be the column nale and the customer name and your third parameter the field, ie date column. mail me direct & I'll give you a demo file "Nelson" wrote in message ... Afternoon, I understand the unique count and its working for me I am getting a result list of unique customers, but now I need to get the unique date associated to that unique customer Basically all I want is the date associated to the first time this customer called us and display it next to the result of my unique customer list. Any suggestions? Thanks in advance -- Nelson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count unique dates within each unique ID | Excel Worksheet Functions | |||
Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
How do I count unique values within a date range? | Excel Discussion (Misc queries) | |||
count unique records with latest date | Excel Programming |