Check for unique rows, but ignore one particular column
- by user269148
I have an XML document, that looks like this:
Column A to S with headers, and there are 1922 rows.
This is an backup of some SMS, and I want to get rid of duplicates.
The problem is, that the Time in the readable_date header has been messed up.
There is nothing wrong with the date, but the clock time is wrong, so I have split that column in three, with Year, day and clock.
I know I can use a standard filter, but it only looks for unique rows in a single column.
What I want to perform, is to make a row check similar to this:
F(x)=Check if Column 2A to (infinate) is equal to Column 3A to (infinate), but ignore column(R). IF True, then delete Column 3A to (infinate) Otherwise Check IF column 2A to (infinate) is equal Column 4A to (infinate) and so on.
I need to ignore a particular column in a row every time, and need to do this for a complete sheet. And the formula check should apply for every row, when the first one is done checking for duplicates...
If anyone else has a better solution, please say so.
Anyway, anyone who can help?
