Hello group,
I was looking for some help making a script that will identify the last row used, go through column E to find duplicates, once it finds duplicated it will clear contents of cells D:E and G:L on the row leaving only the first instance of the number intact. I do not want to delete the cells as it will change the alignment of other cells and thus ruin the spreadsheet.
There may be only 2 lines or 4 or 5 lines duplicate but the duplicated will be grouped together.
Thanks
I was looking for some help making a script that will identify the last row used, go through column E to find duplicates, once it finds duplicated it will clear contents of cells D:E and G:L on the row leaving only the first instance of the number intact. I do not want to delete the cells as it will change the alignment of other cells and thus ruin the spreadsheet.
There may be only 2 lines or 4 or 5 lines duplicate but the duplicated will be grouped together.
Thanks