Hi,
I'm having an issue with counting words across columns. I'm looking for a solution using multiple index formulas
<tbody>
</tbody>
In the case above Index selects 'Keep' but I'm looking for a formula that will pick the word from each row into the total.
Can anyone advise?
I'm having an issue with counting words across columns. I'm looking for a solution using multiple index formulas
Team 1 | Team 2 | Team 3 | Total | |
Keep | =INDEX(A2:C2,1,1) | |||
Delete | ||||
Keep | ||||
Keep |
<tbody>
</tbody>
In the case above Index selects 'Keep' but I'm looking for a formula that will pick the word from each row into the total.
Can anyone advise?