CODEWITHSUNDEEP
excelfilterfilteringadvanced-filter
Bartu Saner
Bartu Saner

Reputation: 23

Filtering a column with another columns values

I assume this is related to advanced filter, but I could not succeed until now with it.

I have 2 Columns, Column A has 2000 number values, Column B has 6000 number values. I want to filter Column B with Columns A values (means I need to set 2000 filters).

I know how to filter single or multiple values, as it is easy by selecting checkboxes, but since it is 2000 numbers to filter, I can not do this manually.

How can I filter Column B with the whole Column A values?

Upvotes: 2

Views: 8108

Answers (1)

zipa
zipa

Reputation: 27889

Add this formula to column C:

=COUNTIF(A:A,B1)

And scroll it to the end of column B.

Now filter column C for values greater than 0.

Upvotes: 4

Related Questions