CODEWITHSUNDEEP
excel
Chris Hansen
Chris Hansen

Reputation: 8647

How to exclude values in excel

I have a simple excel problem:

I have columns A, B, C, D how can I get all the values that are in column A that are not in column B +C +D together in excel?

Upvotes: 0

Views: 475

Answers (1)

Pieter Geerkens
Pieter Geerkens

Reputation: 11883

Add a calculated column E that is set to 1 if A <> B and A <> C and A <> D, else is set to 0.

Using the Auto-Filter function on the Data Ribbon select only those rows that have a value of 1 in column E.

Upvotes: 1

Related Questions