Hi All
Please I have a spreadsheet with Columns A to AE, I need to find out the duplicate rows if the cells in columns B, C, D and F are matched with another row. I expect those duplicate rows should be highlighted in cell column A (not the whole row) for checking.
The spreadsheet has unknown total number of rows.
Please could anyone give me an idea how to create this macro? Many thanks.
Please I have a spreadsheet with Columns A to AE, I need to find out the duplicate rows if the cells in columns B, C, D and F are matched with another row. I expect those duplicate rows should be highlighted in cell column A (not the whole row) for checking.
The spreadsheet has unknown total number of rows.
Please could anyone give me an idea how to create this macro? Many thanks.