Filter and search for differences between columns
3 posts · Closed
rmpf2 Guest
I am wondering, is it possible to filter and search for differences between columns? Like a comparison, to find when specific values are not the same.
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...
Andrew SoftPerfect
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:
rmpf2 Guest
Andrew, that's pretty amazing.
Thank you!
This topic is closed.
It has had no new posts for over a year, so the software versions it talks about may be out of date.
Start a new topic in Network Scanner if you have a similar question.