Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a large spreadsheet (20,000+ rows) with company names (column A),
employee names (column B), and whether each employee is active ("1"=active, "0"=inactive - column C). This spreadsheet is sorted by company name, then by employee name. On a separate sheet I have a drop-down where you select a company. That selection populates a second drop-down with ALL the employees of that company (getting the list from the first spreadsheet mentioned above). I am having a difficult time coming up with an array formula that will allow me to populate the second drop-down with only the ACTIVE employees of the selected client. Can anyone help with this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate an array that is a subset of a larger array? | Excel Worksheet Functions | |||
Can I create a reservation book for a small hotel? | Excel Discussion (Misc queries) | |||
Small Array is too big for AVERAGE Function? | Excel Worksheet Functions | |||
How do I create very small graphics in ONE cell? | Charts and Charting in Excel | |||
How can I create a label over a small chart? | Excel Discussion (Misc queries) |