Sum of reoccurring names in a column ? Need to count each name only once..
wondering how this could be counted...
Say I have a workbook with thousands of transactions with a couple hundred different Clients.
Each row is a unique transaction.
In 'Column A' I have the Client names. Is there a formula to easily count how many Clients I have ?
I'm stumped --- any ideas ? much thanks
Last edited by syncguy; 02-25-2012 at 08:32 PM.
Check out the attached spreadsheet, basically I use a countif and if 1 then record the name in a new column. Then you can count on that column
There is probably a more elligant way, but the following formula will give a "1" for unique values (except for the very 1st entry, Count the results to get the total unique names...
=IF(ISNUMBER(MATCH(A13,A14:$A$19,0)),0,1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
that'll work ! thanks!
Glad to help, please mark as solved if you have your sollution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks