Compare two columns in Excel and delete duplicates

Consider you have two column namely, All students and passed students.

Now you need to write the students status and failed students list from the available all students list and passed students list.

All Students Passed Students

AAA GGG
BBB EEE
CCC AAA
DDD HHH
EEE CCC
FFF
GGG
HHH

In the above pass/fail added using this formula,
=IF(ISERROR(MATCH(A3,$B$3:$B$7,0)),”FAILED”,”PASSED”)

Duplicate - Pass,Fail

and list of failed students taken using this formula,
=IF(ISERROR(MATCH(A3,$B$3:$B$7,0)),$A3,””)

failed filter

Thanks for reading this post…
Add if you want to add anything to this post in the below comment area……….

454 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *