| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count unique values if 2 variables
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count unique values if 2 variables
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count unique values if 2 variables
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values | Excel Worksheet Functions | |||
| Count Unique Values | Excel Worksheet Functions | |||
| Count unique values | Excel Discussion (Misc queries) | |||
| count unique values, if ... | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
Linear Mode
