Need help on this!

Hi guys,

i have a question that needed to solve.

In my excel i have 2 columns
For example,

Both columns have similar/same data inside but they have some values that are different from each other.
Example column A does not have D5 ,D2,D1,I want to form another column which shows values that column A does not have. (D5,D2,D1).
Thanks in advance if any one can help!

Assuming data is in A1:B7 and you are listing commencing at C1, Try:

=IFERROR(INDEX($B$1:$B$6,SMALL(IF(ISNA(MATCH($B$1:$B$6,$A$1:$A$6,0)),ROW($A$1:$A$6)-ROW($A$1)+1),ROWS(C$1:C1))),"")

Confirmed with CTRL+SHIFT+ENTER not just ENTER and then copied down.

Its works thanks.

Hi there, if I do not want duplicate in column C, how do Iedit the formula? Thanks

Insert a row above so data starts in Row 2, then add another formula in D2:

=IFERROR(INDEX($C$2:$C$7,MATCH(0,INDEX(COUNTIF($D$1:$D1,$C$2:$C$7),0),0)),"")

Confirmed with CTRL+SHIFT+ENTER not just ENTER and then copied down.