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
1	X	YYYY		ZZ
2	300.26	301.66		302.58
3	280.26	280.12		280.97		280.12	280.26	280.97
4						YYYY	X	ZZ

<tbody>
</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