count unique values if 2 variables
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.
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
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))
--
Biff
Microsoft Excel MVP
"Tony7659" wrote in message
...
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.
|