| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Compare & Delete
I have 2 list of data
All student ----------- John Peter Mary Anne Belle Cindy Doreen Ellen Gerry Jane Hazel Lynn Kelly Sally Tani Ruby Wendy....5000 students Special Students ---------------- Belle Jane Hazel Ruby.... 60 students I need to compare All students against Special Students. If matched, mark such students in 'All'list so that deletion can be done manually. If possible, automatically. Can someone help me. My guess is that I have to use LookUp function. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
| how do I delete a worksheet from my workbook | New Users to Excel | |||
| Delete row depending on criteria | Excel Discussion (Misc queries) | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| Is there a way to compare 2 spreadsheets with Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
