Forum Discussion

anmac1789's avatar
anmac1789
Copper Contributor
Jul 25, 2024

How to get the cell number of each duplicate 'block' ?

Hello, everyone, there are multiple duplicates in column A and i want to get the cell number of each duplicate "block". How can I do this ?

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    SCAN() function may work. Post few sample data and show your desired output to make your question more understandable. You may also attach a sample excel file with dummy data.

Resources