Forum Discussion
Fill In Column Based on Other Column Value without Blanks
Hello!
In an excel sheet, I have made individual rows that includes a name and have entered a 1 in columns C-I when the corresponding name is in office that day. For example, A2- Resident 1 B2- 1 C2- 1 meaning "resident 1" is in office Monday and Tuesday. Now, I have 30 names in column A. Is there a formula I can use to generate the names that are in office on Monday in a different area of the excel sheet without blanks? Such as the A column reading: A6- Monday A7- "Resident 1" A8- "Resident 3", etc.
Thanks in advance!
| A | B | C | D | E | F |
1 |
| Monday | Tuesday | Wednesday | Thursday | Friday |
2 | Resident 1 | 1 | 1 |
| 1 |
|
3 | Resident 2 |
| 1 | 1 | 1 |
|
4 | Resident 3 | 1 | 1 |
|
|
|
5 |
|
|
|
|
|
|
6 | Monday |
|
|
|
|
|
7 | Resident 1 |
|
|
|
|
|
8 | Resident 3 |
|
|
|
|
|
9 |
|
|
|
|
|
|
