Hi,

I have 2 columns of data...as follows

Col A Col B

0001 123
0001 123
0001 111
0002 146
0002 146
0003 234
0003 234
0003 100

I want to be able to count the number of unique entries in Col B using Col A
as the criteria....

Answer

0001 2
0002 1
0003 2

and so on....

Probably an array function but not sure....any help appreciated

Chris