| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find unique values using 2 variables
I have 2 columns of data: 1 numeric (with some " " from the formula) and 1
text. I need to find the count of rows with unique values in column 2 and numbers in column 1. Any ideas? Thanks! Tony. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find unique values using 2 variables
Sounds like a Pivot table...
data - Pivot Table Drag both columns to your Row fields. Right click, select field settings and select None under subtotals. Grab your text field and drop into data items to get a count where your text and numeric fields are unique... "Tony7659" wrote: I have 2 columns of data: 1 numeric (with some " " from the formula) and 1 text. I need to find the count of rows with unique values in column 2 and numbers in column 1. Any ideas? Thanks! Tony. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find unique values using 2 variables
See your other post.
If the replies there don't do what you want then a better explanation is needed. Include a small sample of your data and tell us what result you expect. -- Biff Microsoft Excel MVP "Tony7659" wrote in message ... I have 2 columns of data: 1 numeric (with some " " from the formula) and 1 text. I need to find the count of rows with unique values in column 2 and numbers in column 1. Any ideas? Thanks! Tony. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count unique values if 2 variables | Excel Worksheet Functions | |||
| Macro to find and record Unique values? | Excel Discussion (Misc queries) | |||
| how do I find and sort unique values from a column | Excel Worksheet Functions | |||
| To find Multiple values in column B for a unique value in column A | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
Linear Mode
