Example:
Column 1(Logged User Name) Column 2(Email) Mike [email protected] Peter [email protected] Jan [email protected]In the second row we can see the difference between 'Peter' and 'Pete'. Any idea how to achieve that? If it is possible...
Column comparison: how to find and filter out differences between columns
Started by rmpf2
|
|
Re: Column comparison: how to find and filter out differences between columns 31 October 2020, 13:17 |
Sure, that is possible.
First, create a virtual column that extracts the part before the @ character in email addresses. Let's call it Email Login:
Then, use the filter that highlights the rows where the columns do not match:
First, create a virtual column that extracts the part before the @ character in email addresses. Let's call it Email Login:
Then, use the filter that highlights the rows where the columns do not match: