Counting outputting Unique Values

[DrewAKA]

I am looking for a way to do the following:

I have a list of values

cat
dog
dog
horse
dog
mouse
cat

I want to be able, on another sheet, to output the unique values and count the number of times they come up. so on another sheet it would say

cat 2
dog 3
horse 1
mouse 1

and if I added values it would add it to the correct area

Any thoughts??

Thanks

Drew

[mccreaso]

Hi,

to find duplicates try this

http://www.cpearson.com/excel/duplicat.htm


To get the number use the COUNTIF function built into excel

mccreaso

[Carim]

Hi,

What about a simple pivot table ...?

[DrewAKA]

Pivot tables didn't seem to do what I wanted it to do, but maybe i was using it wrong,

I was able to retrieve the data, and I can count the data, but i'm still missing 2 key parts, I can't seem to get rid of the blanks and I can't seems to move only unique pieces of data

so if i have

dog
cat
dog
mouse

dog

cat
mouse
dog

I want it to export

dog 4
cat 2
mouse 2

[Schwizer]

Here's my shot at the this. I'm assuming that you've got the counting part done locked down.

Please Login or Register  to view this content.

In my sheet, I made the search area a named range called "Wholerange" but you can make this whatever.

Hope that helps

B

[DrewAKA]

Do you have any other thoughts??
Is there an easy way to do this?

[DrewAKA]

just kidding about my last post, didn't see the one above
let me check to see if it worked

[DrewAKA]

Thanks for the Help I found a solution

Please Login or Register  to view this content.