Forum Discussion
Return multiple rows with matches
I am trying to compare a variable set of numbers that will be pasted in by a user with two different columns in a table and then outputting the rows that match in either column. I would like to event...
You may try free CompareSheets (without space) add-in from Microsoft Store, it has also a built in algorithm that identifies the unique identifiers, as well has an option you can exclude from comparison (but not from output) columns that you do not want to track, will show what was changed in the rows and columns and therefore are merged in one output. I think that is what you are looking for.