excelexcel-formulamatchworksheet-functioninput-filtering

Filter information in two columns

I need a hint is solving Excel task. I have two columns with data (let's say column A contains a list of people I have met in May; column B a list of people I am planning to meet in June).

Is there a function in Excel which will compare both columns and give me a list of people whom I have met in May but who are not included in the list of planned meetings in June, and show results in column C?

Solution

  • With data like:

    enter image description here

    In D1 enter:

    =IF(ISERROR(MATCH(A1,B:B,0)),1,"")

    and copy down and then in C1 enter:

    =IFERROR(INDEX(A:A,MATCH(ROW(),D:D,0)),"")

    and copy down. This results in:

    enter image description here