Forum Discussion
Sabeel
Jan 07, 2020Copper Contributor
Please help to find out unmatched data formula
Subodh_Tiwari_sktneer
Jan 07, 2020Silver Contributor
Please find the two files, one with an Array Formula to get the desired data and another with Power Query based solution.
For the formula solution, you will find the below Array Formula in M2 which is copied across and down.
=IFERROR(INDEX(A$2:A$9,SMALL(IF(ISNA(MATCH($A$2:$A$9,$E$2:$E$3,0)),ROW($A$2:$A$9)-ROW($A$2)+1),ROWS(A$2:A2))),"")