count unique values if 2 variables

  • Thread starter Thread starter Tony7659
  • Start date Start date
T

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.
 
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))
 
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))
 
Oops!

Left out something important.
Try this array formula** :
Click to expand...

** 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.
 
Oops!

Left out something important.
Try this array formula** :
Click to expand...

** 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.
 
Back
Top