View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
March March is offline
external usenet poster
 
Posts: 34
Default Need Help Excel Formula

I have the excel sheet like below (sheet1)

sheet1

A B C
1 QC1 QC2 QC3
2 10 15 9
3 21 19 25


I would like to have the result in Sheet2 show like below

sheet2

A B C D
1 max Sys min Sys
2 15 QC2 9 QC3
3 25 QC3 19 QC2


I don't know how to build formulas to get the result in sheet2.


Please give me suggestion.


Thanks,

March