| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locate unique items
Column A lists Clients, Column P lists Yes/No against the client name. Some
clients are listed more than once and some clients may have either yes or no against their name: John Yes John No John Yes Dave No Jane Yes I somehow need to extract a unique list of clients where each of their respective records is Yes. So, in the example above, I would want two records returned, John and Jane. Any ideas or suggestions welcome because there are a lot of records. -- Thanks, MarkN |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a formula to count only unique items in a column? | Excel Worksheet Functions | |||
| Setting up a validation of data listbox to provide the unique items within a range | Excel Worksheet Functions | |||
| How do I set up a formula to count only unique items in a column? | Excel Worksheet Functions | |||
| create an array with unique items IN MEMORY | Excel Worksheet Functions | |||
| Count of unique items meeting condition | Excel Worksheet Functions | |||
Threaded Mode
