• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

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!

Excel Sample
0
itsmevic
Asked:
itsmevic
  • 3
2 Solutions
 
barry houdiniCommented:
I'm not quite clear what you need to do? The Accounts you show in the example are all different aren't they? Are you saying there are a total of 8 USER5s in the data, 5 USER10s etc?

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
0
 
sentnerCommented:
Your best bet would be to create a pivot table.  If you need guidance doing that, let us know.  
0
 
barry houdiniCommented:
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
0
 
barry houdiniCommented:
Here's an example

barry
27407632.xls
0
 
itsmevicAuthor Commented:
Both solutions worked great, however the pivot table seemed to help better in this particular case.  Thank you both very much for your input.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now