3 minimums

[hsandeep]

3 values are there in B2, C2 & D2.
How to get Minimum, 2nd minimum & 3rd minimum in E2, F2 & G2.

Thanks in adv

 

[pjmorris]

Hi,

In E2: =SMALL($B$2:$D$2,1)

Then copy to F2 and G2, but replace the 1 with 2 and 3 respectively:

F2 is =SMALL($B$2:$D$2,2)
and
G2 is =SMALL($B$2:$D$2,3)

regards

 

[Jonmo1]

You can try the SMALL function..

E2: =SMALL(B2:D2,1)
F2: =SMALL(B2:D2,2)
G2: =SMALL(B2:D2,3)

 

[steve the fish]

Or if you want to drag across:

=SMALL($B$2:$D$2,COLUMNS($A$1:A1))

 

[hsandeep]

You can try the SMALL function..

E2: =SMALL(B2:D2,1)
F2: =SMALL(B2:D2,2)
G2: =SMALL(B2:D2,3)

It WORKS. Thanks

 

[Jonmo1]

You're welcome.

 

[hsandeep]

You're welcome.

Pls ...elaborated..

Sheet1

	B	C	D	E	F	G	H	I
X	YYYY		ZZ
					YYYY	X	ZZ

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]300.26[/TD]
[TD="align: right"]301.66[/TD]

[TD="align: right"]302.58[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="bgcolor: #ffff00, align: right"]280.26[/TD]
[TD="bgcolor: #ffff00, align: right"]280.12[/TD]

[TD="bgcolor: #ffff00, align: right"]280.97[/TD]

[TD="bgcolor: #99cc00, align: right"]280.12[/TD]
[TD="bgcolor: #ffcc00, align: right"]280.26[/TD]
[TD="bgcolor: #99ccff, align: right"]280.97[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

</tbody>

Minimum, 2nd minimum & 3rd minimum are in G3, H3 & I3.
Also required: 'Headers' of the input columns in G4, H4 & I4.

 

[Jonmo1]

In G4 and filled right.
=INDEX($B$1:$E$1,MATCH(G$3,$B3:$E3,0))

 

[hsandeep]

In G4 and filled right.
=INDEX($B$1:$E$1,MATCH(G$3,$B3:$E3,0))

It WORKS. Thanks