Find and display duplicate data

P

Plebless

Hi,

I have the following data:

Sheet1 Sheet2

53446 Query+, 00053353446
53447 Query+, 00055353447
53448 Query+, 00053353448


The last 5 digits from each column on sheet2 are the same numbers as the
colums on sheet1. Is there any possible way that a formula or an add-on be
applied to this to display these duplicate results????

Please help

Thanks
 
Top