L
Luke
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.
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.