Originally Posted by
Will
Hi all,
Just wondered if there are any EXCEL boffins out there who might be able to tell me who to do the following :-
I've got an EXCEL spreadsheet with 11 columns (fields) and 92 rows of data. One of the columns contains surnames.
I have a list of 12 surnames. If any of those 12 surnames happen to be the surname that appears in the surname column, then I want that row of data to remain as is. However, I want to delete all the remaining rows of data (i.e. where the surname columns data isn't equal to any of the 12 surnames in my list).
Is there anyway of doing this automatically? Apart from the risk of human error, this is a process that I'm going to have to repeat quite often so I don't want to have to do this manually if possible.
I'm guessing that a bit of c-sharp or vb script might be necessary, but if so I don't know where to start.
Anyone got any ideas?
Bookmarks