Hi guys and girls,
I pull data from a site which produces rows with 60 cells of data.
Each time rows get pulled in, and it could be duplicates.
Now I want to compare if the row I pull in already exists - I do this via a simple countif on a unique id.
Then I compare the rows via:
If that returns false, there's differences between the two rows.
Question I have is - how can I capture which columns are different between the two rows, without looping through them (because that would mean looping 60 cells).
Basically I want to return the column headers of the columns which differ into a string - in as little lines of code as possible
Any assistance is greatly appreciated.
Bookmarks