Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count unique fields
In a row I have 4 to 5 unique fields, that can appear in more than 1 column.
I have a function to count all the text fields but I would like them separated into unique counts. Exp: blue red green red red blue green green = how many red, how many green, etc. I would like each result in a different cell. Thanks I am sure this is simple, but it doesn't seem to be working out. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count unique fields
hi
countif.... =countif(A1:G1,"red") you will need a countif forumula for each unique value. Regards FSt1 "megz12" wrote: In a row I have 4 to 5 unique fields, that can appear in more than 1 column. I have a function to count all the text fields but I would like them separated into unique counts. Exp: blue red green red red blue green green = how many red, how many green, etc. I would like each result in a different cell. Thanks I am sure this is simple, but it doesn't seem to be working out. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count unique fields
Thanks, that works great!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique Text Fields | Excel Discussion (Misc queries) | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
Find top date for unique fields | Excel Discussion (Misc queries) | |||
Vlookup for non-unique fields | Excel Discussion (Misc queries) | |||
Return unique fields only - but not a filter? | Excel Worksheet Functions |