| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a separate list of duplicates
I have a list (of names of employees inducted) called AllData. On another
sheet, I want to be able to enter a name in (say) A1, and have the rows below list all the entries from AllData that have that name. This is (for instance) to find all the "Smiths" and "Jones". Vlookup only finds the first instance, so if we have inducted 3 people with the surname "Smolenskovnich", then my new list would have all 3, and their induction details. Example A1 - Enter "Smolenskovnich" A3:C6 would then list.... LastName FirstName DateInducted Smolenskovnich Ivan 1/1/08 Smolenskovnich Ivana 23/2/08 Smolenskovnich Evan 2/2/08 Thanks learned gurus. OM (Old Man learning Excel) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
| How can I create a list of random numbers with no duplicates? | Excel Discussion (Misc queries) | |||
| sort list of players by team from player list on separate sheet | Excel Worksheet Functions | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
| How do I create a validation list on a separate worksheet? | Excel Worksheet Functions | |||
Threaded Mode
