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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel function to select unique values...
Couple of possibilities. You can use a Pivot Table - Data - Pivot Table, and
Place the salesperson column in the row field. Click and drag to bottom of list and your row count will be in the Name box at top right. Or, if you only want specific names, you can type the names, then =countif(A:A,repname) " wrote: 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 |
Reply |
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 |