sirloin16oz
New Member
- Joined
- Mar 5, 2019
- Messages
- 3
Hi folks,
Need your help. I'm trying to find an equation to insert into cells E2:G5 that will look for the number of occurrences of the number 1 in a row, and then output the column header. Ive been googling, and it seems this would require an equation using a combination of index, match, and smalls and after two days of looking into this, I cant figure it out.
Would really appreciate your input and help on what equation I could use.
Thank you!!!
Vince
<tbody>
</tbody>
Need your help. I'm trying to find an equation to insert into cells E2:G5 that will look for the number of occurrences of the number 1 in a row, and then output the column header. Ive been googling, and it seems this would require an equation using a combination of index, match, and smalls and after two days of looking into this, I cant figure it out.
Would really appreciate your input and help on what equation I could use.
Thank you!!!
Vince
A | B | C | D | E | F | G | |
1 | Red | Green | Blue | 1 | 2 | 3 | |
2 | Bob | 1 | 1 | Red | Green | ||
3 | Mike | 1 | 1 | Green | Blue | ||
4 | Joe | 1 | 1 | 1 | Red | Green | Blue |
5 |
<tbody>
</tbody>