FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,366
- Office Version
- 365
- 2016
- Platform
- Windows
Hello,
This is returning the filtered items from Column B by searching Column A for what's selected in D1, but how can I skip columns? Versus retuning in D2:G2, I'd like the results to be D2, then F2, then H2, the J2, etc.
This is returning the filtered items from Column B by searching Column A for what's selected in D1, but how can I skip columns? Versus retuning in D2:G2, I'd like the results to be D2, then F2, then H2, the J2, etc.
OSC Groupings.xlsb | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | HDR | Division | SPT | ||||||
2 | SPT | Business Operations | Business Operations | Clinical Operations | Financial Operations | Service Commad Structure | |||
3 | SPT | Clinical Operations | |||||||
4 | SPT | Financial Operations | |||||||
5 | SPT | Service Commad Structure | |||||||
6 | DFX | Behavior Health Services | |||||||
7 | DFX | Admin/Locations | |||||||
8 | DFX | Dental Laboratory | |||||||
9 | DFX | Dental Specialties | |||||||
10 | DFX | General Denistry | |||||||
11 | COL | Information Technology | |||||||
12 | COL | Logistics | |||||||
13 | COL | Ambulance | |||||||
14 | COL | Emergency Medicine | |||||||
15 | LXC | General | |||||||
16 | LXC | Trauma | |||||||
17 | LXC | Inpatient Services | |||||||
18 | ETR | Primary Care | |||||||
19 | ETR | Specialty Care | |||||||
20 | ETR | Surgical Services | |||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2:G2 | D2 | =TRANSPOSE(FILTER($B$2:$B$20,$A$2:$A$20=D1)) |
Dynamic array formulas. |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
D1 | List | =$Q$2:$Q$6 |