Forum Discussion
Excel display common values of its corresponding values
Hi sir/Madam, I am really struggling to compare and display the values in excel. My requirement: I have excel sheet with two tabs. First tab has two columns A and B. A is having values of i...
Hi Gouse,
It looks like in your sample all ID:s from second sheet are in first one plus some ID:s are repeated.
Anyway, the easiest id to do with Power Query - load tables from both sheets, merge them with inner join on ID and return result to Excel sheet.