Max Values
I'm assuming here that you have the value 'product' in cell A1 her...
Type the following in F2:
=if(max($b2:$e2)=b2,b$1,if(max($b2:$e2)=c2,c$1,if( max($b2:$e2)=d2,d$1,$e1)))
"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
|