count unique items

[Andrew]

I have two columns of data. One numeric (1-12)and one text. i need to get a count of the unique text data items based on a range in the number column. For example, how many unique text items do I have that falls within the range of >=8 and less than 9.

Any suggestions?

 

[isabelle]

hi Andrew,


array formula to validate with ctrl + shift + enter

=COUNT(1/FREQUENCY(IF(A1:A100<9,MATCH(B1:B100,B1:B100,0)),ROW(INDIRECT("1:"&ROWS(B1:B100)))))
-COUNT(1/FREQUENCY(IF(A1:A100>=8,MATCH(B1:B100,B1:B100,0)),ROW(INDIRECT("1:"&ROWS(B1:B100)))))



--
isabelle



Le 2012-03-06 08:40, Andrew a écrit :

I have two columns of data. One numeric (1-12)and one text.

i need to get a count of the unique text data items based on a range in the number column.

For example, how many unique text items do I have that falls within the range of>=8 and less than 9.