| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate Data Search
Cell A1 is the following text data "SCR: 27001.01, 27002.01, 27003.01,
27004.01, 27005.01." Cell a2 is the following text data "SCR: 29001.01, 29002.01, 29003.01, 27004.01, 29005.01." 27004.01 is duplicated text in both cells. Is there a formula or a macro to check for duplicated data (that has been entered as text)? -- Thomas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| duplicate data in columns | Excel Discussion (Misc queries) | |||
| Is there an easy way to filter duplicate rows of data in excel? | Excel Discussion (Misc queries) | |||
| Finding DUplicate Data set in Worksheets | Excel Worksheet Functions | |||
| How do I compare data from 2 worksheets to find duplicate entries | Excel Discussion (Misc queries) | |||
| Removing Duplicate Data | Excel Worksheet Functions | |||
Threaded Mode
