Finding duplicates in 2 or more tabs

Hi Hai-anh,

Thank you for the forum question.

Well everything is possible in Excel.

If you have a unique id for each record you can use the vlookup function to compare two tables. I have attached a workbook with 2 sheets. In each sheet you will find a list. On the first sheet I have used the vlookup to compare the staff id and if the vlookup cannot find the staff id on the second sheet and returns #N/A it is not a duplicate.

If you do not have a unique value to lookup you can use the concatenate function to concatenate a number of cells to create a unique value you can lookup.

It can also be done with VBA but the you will have to write the code.

I hope this will help you to do what you need.




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector