Forum Discussion
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 ?
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.