Max Values
Alternatively, if you want the layout as in your example, then put the
headings for the lower table in A10:B10 and a, b, c in A11:A13 and
this formula in B11:
=INDEX(B$1:E$1,MATCH(MAX(B2:E2),B2:E2,0))
and copy this down into B12:B13.
Hope this helps.
Pete
On Oct 10, 10:06 am, THFish wrote:
How do you extract max values from a row of data.
Ex.
product dist a dist b dist c dist d
a 5 3 9 1
b 8 7 1 3
c 1 4 6 9
to display like
Product most in stock
a dist c
b dist a
c dist d
Any help would be greatly appreciated
|