Creating a drop down list based on another cell

**IYWILSON001** · 09-03-2021, 08:46 PM

Hi,

Capture.PNG

I am trying to create a drop down list that only show the people listed in column B if they have the word "active" in column A.

Based on the attached spreadsheet the only people that should be showing in my drop down list is Angel & Abigail.

Can someone please help me out. Unfortunately I am unable to attach the file.

**Sam Capricci** · 09-03-2021, 10:52 PM

Rather than a dropdown as it could get very long, I would consider adding a formula in col C like... =IF(A2="","",IF(A2="active",1,0))
then lock in the top row and add a filter to filter on the #1. I've attached an example.
OF course you could not even bother with the col C formula and just filter on the active people using col A and the filter.

Creating a drop down list based on another cell

LinkBack

Thread Tools

Rate This Thread

Display

Creating a drop down list based on another cell

Re: Creating a drop down list based on another cell

Thread Information

Users Browsing this Thread

Similar Threads

NEED HELP creating a drop-down based on selection from first drop-down on dynamic list

Creating IF formula based off drop-down list selection

Creating a drop down list that filters data based on selection??

Creating a SUM in a Table based on 2 selections from a drop down list

Creating a list of hyperlinks based on the results of a drop down box

Creating a drop down list that is based on the contents of another cell

Bookmarks

Bookmarks

Posting Permissions