| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Unique entry from Concatenated list
example of Data
-------------------- Col A Col B (By using CONCATENATE function) A a,a,b,d B d,d,c,a C b,h,r what i need in Col C is based on the criteria in Col A how many unique entries are there in Col B, i.e. if Col A = B then how may unique records are there in Col B, Answer is 3 (d,c,a) what formula should i use for this, NOTE : Col B each Concatenated entry is seperated by a "," |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
| Advanced filter and a list | New Users to Excel | |||
| Counting unique records with additional criteria | Excel Worksheet Functions | |||
| quicker entry of list rows | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Threaded Mode
