March wrote...
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
....

So going through the table in Sheet1 row by row?

Sheet2!A2:
=MAX(Sheet1!A2:C2)

Sheet2!B2:
=INDEX(Sheet1!$A$1:$C$1,MATCH(A2,Sheet1!$A2:$C2,0) )

Sheet2!C2:
=MIN(Sheet1!A2:C2)

Copy Sheet2!B2 and paste into Sheet2!D2. Then select Sheet2!A2:D2 and
fill down as far as needed.