find min in a row and display corresponding top cell value of that column

**busybee235** · 10-07-2012, 11:09 AM

For eg.

.....A.......B.......C.......D.......E............F
1...1.00...1.33...1.5....1.75....2.00.......top cell value
2...0.60...0.27...0.10...0.15... 0.40.......1.5(C1)
3...0.78...0.45...0.28...0.03... 0.22.......1.75(D1)
4...0.78...0.45...0.28...0.03... 0.22.......1.75(D1)
5...0.78...0.45...0.28...0.03... 0.22.......1.75(D1)
6...0.60...0.27...0.10...0.15... 0.40.......1.5(C1)

Columns A1 to E1 contain ratios.
Column F should display corresponding top cell value of the minimum value in each row.

Thanks

**martindwilson** · 10-07-2012, 11:20 AM

=INDEX($A$1:$E$1,MATCH(MIN(A2:E2),A2:E2,0)) will do it

**Thalassa** · 10-07-2012, 11:22 AM

Try in F2 copied down

=INDEX(1:1,MATCH(MIN(A2:E2),A2:E2,0))

**icestationzbra** · 10-07-2012, 11:24 AM

another approach:

Please Login or Register  to view this content.

**:) Sixthsense :)** · 10-07-2012, 11:48 AM

Hi,

Copy and paste the below formula in F2 cell

[Formula]
=IF(COUNT($A2:$E2),INDEX($A$1:$E$1,MATCH(MIN($A2:$E2),$A2:$E2,0)),"")
[Formula]

Drag the F2 cell formula for the remaining cells of Column - F.

Refer the attachment file for details.

Hope that helps!

Note: Please don't post the sample data in the body, make it in excel workbook and attach it while asking these type of questions.