Filter Column based off another Column List

beginvbaanalyst

Board Regular
Joined
Jan 28, 2020
Messages
116
Office Version
  1. 365
Platform
  1. Windows
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.
1603569298765.png
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Ezguy4u

Board Regular
Joined
Feb 10, 2010
Messages
148
Office Version
  1. 2019
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,553
Office Version
  1. 365
Platform
  1. Windows
You can do that with the filter function
Excel Formula:
=FILTER(AH2:AI100,AH2:AH100=AC2,"No match")
 

Ezguy4u

Board Regular
Joined
Feb 10, 2010
Messages
148
Office Version
  1. 2019
Platform
  1. Windows
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

Board Regular
Joined
Jan 28, 2020
Messages
116
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

Watch MrExcel Video

Forum statistics

Threads
1,127,606
Messages
5,625,765
Members
416,136
Latest member
senthil_sk

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top