Monday, December 7, 2020

Find the Difference between Two Lists

If you've got two lists or table to compare, most of the time you can use the equal sign to compare the cell values. But sometimes there are complications like having more than one value, values (text or string values) are separated by delimiters (e.g., commas, semicolons, etc.) or the values are not in the "correct" order. Doing the simple cell to cell comparison is not applicable and that's when you can use Power Query to help compare values.

No comments:

Post a Comment