| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting Unique text entries in a sheet with a condition
I have a list of names with mutiple entries for most of them
I need to count the unique names but that only meet another criteria eg A B Uk Mike DE Fred Uk Mike Ch Ted Uk Rose What I need is a formulae that will let me specify if colulm A is UK count the unique names in colum B - the answer should be 2 (Mike & Rose are in UK) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Unique Cells When Spread Sheet is Filtered | Excel Worksheet Functions | |||
| counting unique instances of text in a list | Excel Worksheet Functions | |||
| Clicking cells on sheet creates Text Box. How do I turn this off? | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
| Counting Numbers with Text | Excel Worksheet Functions | |||
Threaded Mode
