I will try to explain better what’s my issue, I have an Excel file, which contains mulipltes values, which most of them are the same, for the first column. Which also, i will be using later.
What i have to do, is on each row, i take the value on the first column, enter it on an application, do some stuff and save it on the application. BUT if the value of the first row and first column is duplicated on more column, i have to process all that rows which have the same value before i save my work. If the value changes, i save and start over again with the new value. I hope this clears it for you.
I though about counting the duplicate values and map it to the other columns, than do the same of all other rows the same way. But couldn’t find the right way to do.
TEST.xlsx (19.3 KB)