CODEWITHSUNDEEP
excelexcel-formulamatchworksheet-functioninput-filtering
Janis Daksa
Janis Daksa

Reputation: 15

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?

Upvotes: 1

Views: 52

Answers (2)

Gary's Student
Gary's Student

Reputation: 96781

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

Upvotes: 0

pnuts
pnuts

Reputation: 59495

No, but a combination of functions achieves the result. Please try: 

=IFERROR(MATCH(A1,B:B,0),A1)

copied down to suit.

If the name is not listed in ColumnC then a number should be returned that indicates the position in ColumnA where the name is present in addition to in ColumnB.

IFERROR
MATCH

Upvotes: 1

Related Questions