itsmevic
asked on
EXCEL 2007: Counting Repetitive Data in Cells
Hello Experts!
I have a spreadsheet that consists of a few columns. One of my columns, the "Account" column I've done a "Sort By" on. I've noticed I have repetitive entries in that column that I'm trying to count. It wouldn't be that bad but this worksheet is rather long so I'm having to manually label each of the same entries (1), (2), (3) and this is what is taking so long. Is there a formula I could use that might make my job a little easier? I've attached a sample of what I'm describing. Any help with this is GREATLY APPRECIATED!
I have a spreadsheet that consists of a few columns. One of my columns, the "Account" column I've done a "Sort By" on. I've noticed I have repetitive entries in that column that I'm trying to count. It wouldn't be that bad but this worksheet is rather long so I'm having to manually label each of the same entries (1), (2), (3) and this is what is taking so long. Is there a formula I could use that might make my job a little easier? I've attached a sample of what I'm describing. Any help with this is GREATLY APPRECIATED!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry, I think I understand now - my formula lableed each occurence with the total number, if you want them numbered 1, 2, 3 etc then modify to this version
=E2&" ("&COUNTIF(E$2:E2,E2)&")"
regards, barry
=E2&" ("&COUNTIF(E$2:E2,E2)&")"
regards, barry
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Both solutions worked great, however the pivot table seemed to help better in this particular case. Thank you both very much for your input.
If so perhaps use a new columns with a formula like this in F2
=E2&" ("&COUNTIF(E:E,E2)&")"
that will put the Account name with the occurrences in brackets
regards, barry