Thread: Max Values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
THFish THFish is offline
external usenet poster
 
Posts: 11
Default Max Values

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