unique count with reference

[carlscott]

Hi everyone ,
Newbie here , it looks a great resource this site ,, wonder if anyone can help me

we have a set of data in 2 columns column A and column B , we would like be able to do a unique count of column B in relation to column A, with the output showing unique items in column A`s and a count of Unique items in Column B


example below ; the output would be A 1 ( as there is only 1 unique item Red) , B 2 ( there are 2 unique items ) , C 3 ( 3 unique items Yellow white and black )

i know it can be done with pivot table but we wish to just copy the data daily to a spreadsheet and have the output columns calculate automatically .. any help is greatly greatly recieved thanks in advance

Column A Column B
A Red
A Red
B Green
B Lime
C Yellow
C Yellow
C white
C Black

[Domski]

This is a duplicate post: http://www.excelforum.com/excel-gene...que-count.html

Please take a moment to read the forum rules.

Dom

[arthurbr]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.