View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] nefarious24@gmail.com is offline
external usenet poster
 
Posts: 2
Default finding min values address and getting value from same column

ok here is what i have.

A B C D E
1 V W X Y
2 1.95 1.55 1.75 2.05 #Display


now in cell E2 i want it to find the minimum value from A2 to D2 and
display the letter above that minimum values column found in row 1
(V,W,X or Y).

so in this example i want W to be displayed in Cell E2.

thank you,
Jonathan