| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing names in a list
I have two very long lists of student names in one worksheet. The names in
A1:A500 is the master list. The student names in B1:B200 have successfully passed their exam. I would like to know which student names are NOT in the second list by comparing it to the master . A1:A500 B1:B200 Answer= John and Steve Joe Joe John Sally Steve Sally |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I import a list of names into a separate form that prints . | Excel Worksheet Functions | |||
| How do I create/filter a list of names without duplications | Excel Discussion (Misc queries) | |||
| Count Unique Names in list w/ Additional Criteria? | Excel Worksheet Functions | |||
| Comparing two List that a "Close" but not Identical | Excel Worksheet Functions | |||
| Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
Threaded Mode
