this seems so simple yet I can't for life of me figure it out. I have two columns of data (see below) - I need a formula that would allow me to count the number of reps in a particular office ignoring diplicate entries (ex. the number I would be looking for in office number 1 would be 2) help please.
Office # Rep #
1 11111
1 11111
1 33333
2 22222
2 34568
3 25466
4 13546
5 13246
Bookmarks