Excel 2010

Hello

I need to know how to make excel display a count of all the same records in table. So for example Column Z has 86000 Entries and i want to a count of all the items that are the same throughout the column.

If i have 1000 entries of Robert-123-#$%-Was-Her3 - I would like to be able to select just those and also get a count.

I dont know much about excel except for basic filtering so pelase be extra clear on how i might do this.

Thanks in advacne!!

Robert
LVL 6
castellansolutionsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

FaustulusCommented:
Presume that you select (or double-click?) any one item in the list and then press a button. What would you like to happen?
1. Would you like your list to be filtered on that item so that all rows that have a different value in column Z than the one you picked are hidden?
2. Would you like to display a message box informing you of how many items are in the filtered list?
Would you select a cell or a part of a cell?
If you select a part, would that be the leading part or any part?
0
Dan CraciunIT ConsultantCommented:
Use countif(range, criteria), where "range" is your column Z, and "criteria" is the entry you want to find the count for.

http://www.techonthenet.com/excel/formulas/countif.php

HTH,
Dan
0
castellansolutionsAuthor Commented:
Ok... What i am looking for is the "Same Value" on multiple cells. I need to identify a looping value and need to see how many cells have the same value.
0
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

castellansolutionsAuthor Commented:
If you want i can provide a quick screenshot of the values in question
0
FaustulusCommented:
Where and how do you wish to display the requested information?
How do you intend to communicate to Excel which item you are interested in?
0
castellansolutionsAuthor Commented:
This is how i fixed it. I went and selected my value and then filtered on it and now it shows me what i want. thanks for the advise.
0
[ fanpages ]IT Services ConsultantCommented:
I dont know much about excel except for basic filtering so pelase be extra clear on how i might do this.

This is how i fixed it. I went and selected my value and then filtered on it and now it shows me what i want. thanks for the advise.

I would suggest nobody advised you at all.
0
castellansolutionsAuthor Commented:
Ok... I am back to needing help with this i will provide a quick example of my data:

Message Subject (One Column)

$9031 Lenovo x12 Sxaon = World’s Lightest 14” Ultrabook
$1469 Off HP EliteDesk 80000 G5 Large Form Factor PC Only $1779
(Forward to attendees) Please join now, meeting in progress

The above is jsut a quick example of my data, i was able to sort all 135K Rows and got it at least that far but now my last step is count the total occuranes of each of the above examples.

I really need this to be easy i tried using pivot tables and it didnt work out for me. If there is a (free) 3rd party add in i would use that.

Thanks,

Robert
0
castellansolutionsAuthor Commented:
I've tried using different functions but they all want the "criteria" i dont have that as i dont know all of my subjects. I provided 3 as an example but there most likely going to be 300

Also I can highlight all the duplicate entries and color code them, but i still cant count them.
0
Dan CraciunIT ConsultantCommented:
Copy all on a different sheet.
Use Data->Remove duplicates. That will only leave the unique values.
After that use Countif(range, criteria) where "range" is your original data and "criteria" is a cell from your unique data.

HTH,
Dan
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
castellansolutionsAuthor Commented:
So i ended up using pivot tables to do this. It took a few tries but your method also worked.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.