Excel function to select unique values...

[chrisl]

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(D5136,D5136)>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

 

[Sean Timmons]

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)