I am trying to figure out how to do this in a script. I want to loop through all the rows in a pivot table, and compare values from specific columns to the previous row. If I find that the values do not match, I want to highlight the row.
So I would compare the Name column. If they were the same, but the State value was different, the row would be highlighted.
Rows 1 and 2 would match, so no action is taken.
Rows 3 and 4 would not match so would be highlighted.
Since row 2 and 3 have different Name values, they would be ignored.
What I cant figure out is how to loop through the rows and look at specific column values. Does anyone have a script that does something like this?
Please sign in to leave a comment.