Hello all, I have a range of data as table below and looking for the max cost for each item.
Wondering how can I use HLOOKUP to get the max cost.
Thanks for advance!
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>
Result
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Wondering how can I use HLOOKUP to get the max cost.
Thanks for advance!
Item A | Item B | Item C | Item A | Item D | Item B | |
Cost 1 | 2 | 4 | 5 | 10 | 9 | 20 |
Cost 2 | 11 | 8 | 22 | 4 | 8 | 5 |
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>
Result
Item A | Item B | |
Cost 1 | 10 | 20 |
Cost 2 | 11 | 8 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>