Magoosball
Board Regular
- Joined
- Jun 4, 2017
- Messages
- 70
- Office Version
- 365
I have a spreadsheet with 2 separate sheets set up as follows
List
The goal of this is to look at the summary sheet below and populate the State column with the lowest value that matches the department and shift.
Summary sheet:
These aren't numbers on the summary sheet, they are a countifs statement taht counts the state column (C) from the summary sheet for that specific unit and shift. For example there are a count of 456 "Maryland" in column C on the summary sheet.
When a state is populated in the "List" Spreadsheet the formulas on the summary tab would add 1 to that department/state/Day field respectively. Therefor the next item in the list could be impacted from the previous item on the list.
Is this possible with a formula in the State cells on the List spreadsheet?
Thank you in advance!
List
Department | Shift | State |
Home Health | Nights | |
Toys | Nights | |
Toys | Days | |
Sporting Goods | Days | |
Grocery | Days | |
Toys | Nights | |
Furniture | Days | |
Pets | Nights |
The goal of this is to look at the summary sheet below and populate the State column with the lowest value that matches the department and shift.
Summary sheet:
Department | Alabama | Alabama | Alaska | Alaska | Maryland | Maryland | Maine | Maine |
Pets | Days | Nights | Days | Nights | Days | Nights | Days | Nights |
Grocery | 5 | 6 | 9 | 4 | 2 | 34 | 8 | 6 |
Garden | 5 | 879 | 4 | 5 | 62 | 154 | 87 | 52 |
Home Health | 1567 | 79 | 712 | 3 | 456 | 78 | 152 | 12 |
Cosmetics | 1 | 2 | 65 | 79 | 8 | 4891 | 54 | 568 |
Furniture | 45 | 45 | 878 | 9 | 8 | 455 | 657 | 26 |
Toys | 126 | 489 | 897 | 7891 | 324 | 348 | 48 | 9 |
Sporting Goods | 87 | 98 | 7 | 1 | 56 | 4897 | 97 | 321 |
These aren't numbers on the summary sheet, they are a countifs statement taht counts the state column (C) from the summary sheet for that specific unit and shift. For example there are a count of 456 "Maryland" in column C on the summary sheet.
When a state is populated in the "List" Spreadsheet the formulas on the summary tab would add 1 to that department/state/Day field respectively. Therefor the next item in the list could be impacted from the previous item on the list.
Is this possible with a formula in the State cells on the List spreadsheet?
Thank you in advance!