kangelosanto
New Member
- Joined
- Aug 12, 2014
- Messages
- 14
So I've got this data:
<tbody>
</tbody>
And I can't for the life of me figure out how to achieve this:
<tbody>
</tbody>
The Value in B4 can be either AA, AB or a CONCATENATE of the two, I'm not really worried about that part as it should only happen extremely sparingly.
I tried a combination of INDEX(MATCH(MAX etc. but nothing has worked. Help!
A | B | C | D | E | |
1 | AA | AB | AC | AD | |
2 | Name A | 1 | 3 | 1 | 0 |
3 | Name B | 5 | 1 | 0 | 0 |
4 | Name C | 2 | 0 | 4 | 8 |
5 | Name D | 1 | 1 | 0 | 0 |
<tbody>
</tbody>
And I can't for the life of me figure out how to achieve this:
A | B | |
1 | Name A | AB |
2 | Name B | AA |
3 | Name C | AC |
4 | Name D | AA -or- AB |
<tbody>
</tbody>
The Value in B4 can be either AA, AB or a CONCATENATE of the two, I'm not really worried about that part as it should only happen extremely sparingly.
I tried a combination of INDEX(MATCH(MAX etc. but nothing has worked. Help!