| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Uniques EXCLUDING Some Entries
I have one column with both text and numeric entries. What formula can I use
to count the # of uniques, disregarding any cell that contains the word "Unknown" or is blank? For example, in the following, I should get an answer of 2 (which would be AB123 and GF999). The answer is probably something I will be embarrassed that I couldn't figure out..... Cell A1 Unknown Cell A2 AB123 Cell A3 Cell A4 GF999 Cell A5 AB123 Cell A6 Unknown Cell A7 AB123 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aladin...HELP!!! Running Averages of last 10 data entries, excluding blank cells | Excel Worksheet Functions | |||
| Aladin...HELP!!! Running Averages of last 10 data entries, excluding blank cells | Excel Worksheet Functions | |||
| Count number of uniques starting with a given letter? | Excel Discussion (Misc queries) | |||
| Count Uniques within a list based on value of cell... | Excel Discussion (Misc queries) | |||
| How to count uniques of a SUMPRODUCT subset? | Excel Worksheet Functions | |||
Threaded Mode
