Need to identify all the data sets based on given key word

Hi Masters,

I am faced with a challenge of identifying all the probable duplicate issue of Id cards for a list of some 50000 students.

There is a list of student names in Column A with associated fields in subsequent columns.
I would like to use either first name or last name as keyword and pull all the data(all the columns) that either partially or fully match the keyword in second sheet.

I have attached a sample workbook for this.
If anyone can help how this can be done with VBA or formulas, I would be thankful.

I have tried vlookup but it pulls only one data set.

any help offered would be of great timesaver.

Regards,
Kiran

Why not just use Data Sort on the table? In about 15 seconds, I was able to tell that everybody on the list, except Jack hill, had 2 IDs

If you split the Name column into First and Last, you could sort on First + Last and on Last + First.

Disclaimer: I am not a formula man, so the only way that I personally, can see to to extract only the duplicates would be with a VBA Macro.

Others may be able to help with a Formula driven method.

In any Case this post will bump you up the list.

Try this..

I changed the way you were going to show the results to be horizontally stacked (1 person per line).. thats generally the way data is retrieved..

Try the attached Workbook..

Please Login or Register  to view this content.

Thanks APO, it was exactly the way I wanted it....

Hi Apo,
What if I have around 60 columns in "mASTER dATA"??

if you have 60 columns.. and your data is set out as it is in the "mASTERdATA" sheet.. then just change the following line to :

Please Login or Register  to view this content.

Also.. if your are NOT filter by the first column.. change the "1" value to the column number you are filtering by in this line:

Please Login or Register  to view this content.