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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you display entire rows that match a certain criteria... 1
Creating a Chart on form from selected data in query. 0
Duplicating cell values from one sheet to another 3
macro for calculate and compare 0
MATCH 2
how to match between two list using letters 3
Macro to copy data X number of times into a column 0
Formula needed to SUM and COUNT in specific way 7

Top