Hello
I want to compare Scheme A and B sheets, count duplicates in Column A between Scheme A and Scheme B and display result in B6 of sheet Analysis
Please help Would prefer a power query
Hello
I want to compare Scheme A and B sheets, count duplicates in Column A between Scheme A and Scheme B and display result in B6 of sheet Analysis
Please help Would prefer a power query
Last edited by grcshekar; 01-28-2023 at 01:06 AM.
merge A & B with JoinKind.Inner then Table.RowCount
the same for A & C and B & C
Am not so well versed. can you please update my excel sheet it would be of immense help
Last edited by grcshekar; 01-28-2023 at 02:45 AM.
for A&B only
I don't want to update data with every click
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks