Count the unique entries in a column of data
you will have to do 2 things her, use the Unique filter and then use SUMIF
formula.
Assuming that you have data in Col A and B...
Select Col A
Use Advance filter
select unique records
select Copy to and give address as say D1
click OK
The above will list the unique records.
Now in col E, next to each unique record type the SUMIF formula as
=SUMIF(A1:A10,E1,B1:B10)
This will total the values.
HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!
"Remacricky" wrote:
Hi,
I have:
Col A Col B
Dog 5
Cat 3
Boy 2
Dog 3
Cat 9
Boy 1
How can I "filter" this list down so it shows that I have:
Col A Col B
Dog 8
Cat 12
Boy 3
I need to bulk unique entries, while adding their counts (sum) together.
Thanks in advance for any suggestions.
|