Hi there, I have text data in a spreadsheet from call A1 to BA100. The table contact a series of product codes with various information in adjacent calls under certain headings. Many of the cells replicate some information.
I need to remove duplicates without shifting the cells.
I have tried to create a macro with no luck and don't want to use a formula as the table is already massive.
Many thanks
Bookmarks