I have a filepath in each row. I've broken up the path using the backslash as the delimiter. So the columns look like this:
What I'm trying to do is flag the rows that have the same values in the last two rows, ignoring the .lnk extension. The number of filled cells in each row will vary, so only the last two-non blank cells in each row should be compared.
In the example shown above, the 2nd and 3rd rows should be flagged.
How can this be done?
Code:
[tt]C My Data Bob's Stuff Monday green.lnk
C My Data Bob's Stuff Monday Monday.lnk
C My Data Bob's Stuff Tuesday Tuesday.lnk
C My Data Bob's Stuff Tuesday blue.lnk[/tt]
What I'm trying to do is flag the rows that have the same values in the last two rows, ignoring the .lnk extension. The number of filled cells in each row will vary, so only the last two-non blank cells in each row should be compared.
In the example shown above, the 2nd and 3rd rows should be flagged.
How can this be done?