jdautel
05-05-2017, 10:40 AM
So I have a spreadsheet that looks like this:
19097
And goes on for a very very long time. I'm trying to write a simple script that will highlight in red for me each time a card made a purchase on the same date. It's not always sorted from newest to oldest in terms of the transaction date. So I need it to iterate through each sub group and If a date shows up more than once, it highlights both those rows red.
Any ideas?
19097
And goes on for a very very long time. I'm trying to write a simple script that will highlight in red for me each time a card made a purchase on the same date. It's not always sorted from newest to oldest in terms of the transaction date. So I need it to iterate through each sub group and If a date shows up more than once, it highlights both those rows red.
Any ideas?