Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel function to select unique values...
I am trying to count the number of unique records in Excel worksheet.
If this were SQL it would be easy but in excel I have no idea. I am trying to use this function but is is producing errors. =COUNTIF(AND(B5:B136,"=BFS"),(FREQUENCY(D5:D136,D5 :D136)0,1)) Here is an example of the data: salesperson date Brad 18-Sep-08 Brad 18-Sep-08 Tom 18-Sep-08 Ed 18-Sep-08 Brad 15-Sep-08 Tim 15-Sep-08 Brad 14-Sep-08 Thanks for any help! Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to select random values from a list. | Excel Worksheet Functions | |||
What function to select the last 3 small values from a list ? | Excel Discussion (Misc queries) | |||
What function to select the last 3 small values from a list ? | Excel Worksheet Functions | |||
Function to count unique values? | Excel Worksheet Functions | |||
how do I select unique dates from a database in Excel? | Excel Worksheet Functions |