Count unique references

[theta]

Hi

I have the following data. It may be one item, but referenced over several lines. I need to get a unique count :

1 - SINGLE
2 - SINGLE
3 - GROUP
3 - GROUP
3 - GROUP
4 - SINGLE
5 - GROUP
5 - GROUP
6 - SINGLE
7 - GROUP
7 - GROUP
7 - GROUP
7 - GROUP
7 - GROUP
8 - SINGLE

SINGLE COUNT = 5
GROUP COUNT = 3

Any ideas guys?

 

[theta]

Would like it to be based on the reference if possible. I.e. if the reference appears more than once, then count it as a group item. This will prevent any errors where somebody has labelled a group as a single

 

[Robert Mika]

If your data a re in column A:B

C1: Single
C2: Group

In D1 copied down(Array formual, confirm CTRL+SHIFT+ENTER):


=COUNT(1/FREQUENCY(IF($B$1:$B$100=C1,MATCH($A$1:$A$100,$A$1:$A$100,0)),ROW($A$1:$A$100)-ROW(A1)+1))