Hi guys, need some help here..
Got a sheet with names and number on it.. Need to remove names & Numbers in column A & B which are in column E & F (see attached) as they are duplicates....
Hi guys, need some help here..
Got a sheet with names and number on it.. Need to remove names & Numbers in column A & B which are in column E & F (see attached) as they are duplicates....
Probably a simpler way, but this is how i'd do it.
In a blank cell, say H1, type =VLOOKUP(A1,$E$1:$E$60,1,FALSE)
Copy this down the column to the bottom line of data.
Those which are doubled up in column A and E will give the name. Those which are not will give #N/A.
Filter the whole lot, and do a cutom filter of 'does not equal #N/A'
Then delete all the records in colmn A that you don't want (delete the text or the cells, not the entire rows).
Same sort of thing should apply if there are other columns with data
Shooooooo-ryuken!
cheers flump....
Social Networking Bookmarks