Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and display duplicate data
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Duplicate data | Excel Discussion (Misc queries) | |||
How do I find duplicate numbers in a data? | Excel Worksheet Functions | |||
find duplicate data in diffrent column | Excel Discussion (Misc queries) | |||
Can I suppress display of duplicate data in columns? | Excel Discussion (Misc queries) | |||
Another question on how to find duplicate data | Excel Worksheet Functions |