Filter Column based off another Column List

[beginvbaanalyst]

Hi Everyone,

If I wanted to filter data that was in Column AH by data provided from Column AC how would I do that?
Let's say Column AH has 50 values while Column AC here has 10.
I want to filter using Column AC first value (YOG6LOHSP) to show all of the same values in Column AH(YOG6LOHSP) together.
Is this possible with the advanced filter?
I can't seem to get it to work.

 

[Ezguy4u]

There are a couple of ways to view unique items. It has more to do with your requirements than how to isolate these items. My question is why not just insert table for column AH and connected columns. Then you could filter YOG6LOHSP. Also if you could us this XL2BB that is the hot ticket too.

XL2BB Instructions & Download

 

[Fluff]

You can do that with the filter function

=FILTER(AH2:AI100,AH2:AH100=AC2,"No match")

 

[Ezguy4u]

Fluff, I believe that Filter function is only on Excel 365. But since I am a known liar, we have to be careful here. I have Excel 2019 and I don't think I can get that Filter function as an add-on. And beginvbaanalyst didn't say what version he was using. So just to get the ball rolling I like to start some place. Let's see if your formula fills the bill.

 

[beginvbaanalyst]

I do have access to the filter formula.
How does that get what I want though?

 

[Fluff]

I believe that Filter function is only on Excel 365

That's right

beginvbaanalyst didn't say what version he was using

It's on his profile

 

[Fluff]

How does that get what I want though?

It will show you all the rows from col AH:AI that match the value in AC2