count unique values if 2 variables

[Tony7659]

I have 2 columns of data, 1 numeric (maybe with "" due to formula) and 1
text. I need to count any rows with numeric values in column 1 with the same
text values (unique records) in column 2. Any ideas? Thanks!

Tony.

 

[T. Valko]

A1:A20 = numbers
B1:B20 = text entries

Try this array formula** :

=SUM(--(FREQUENCY(IF(ISNUMBER(A1:A20)*(B1:B20<>""),MATCH(B1:B20,B1:B20,0)),ROW(B1:B20)-ROW(B1)+1)>0))

 

[T. Valko]

Oops!

Left out something important.

Try this array formula** :

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

 

[Bernd P]

Hello Tony,

I suggest to use my UDF Pfreq which you can find here:
www.sulprobil.com

Regards,
Bernd