| 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 |
|
#2
|
|||
|
|||
|
assuming student names are in column A and special students names are in
column A in work sheet 2, you can use the following formula, it will insert an X were there are special students and if you want to delete them from original list you can sort the coulmn by X and delete those. Regards, Nikki =IF(ISERROR(VLOOKUP(A3,Sheet2!$A$1:$A$17,1,FALSE)= TRUE),"","X") "Centrol" wrote: 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 |
|
#3
|
|||
|
|||
|
Thanks Nikki. Got it!
"Nikki" wrote in message ... assuming student names are in column A and special students names are in column A in work sheet 2, you can use the following formula, it will insert an X were there are special students and if you want to delete them from original list you can sort the coulmn by X and delete those. Regards, Nikki =IF(ISERROR(VLOOKUP(A3,Sheet2!$A$1:$A$17,1,FALSE)= TRUE),"","X") "Centrol" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
