Find smallest num in array

**Vinodsralian** · 09-25-2010, 01:14 PM

Hi,

I was in the way of finding smallest numbers in array, need any of guys help to figure it out..

Please find sample spreadsheet,explaining prob and desired result!!

Thanks

**shg** · 09-25-2010, 01:39 PM

In B2, =SMALL($B$2:$B$8, SUM(COUNTIF($B$2:$B$8, F$1:F1)) + 1)

... confirmed with Ctrl+Shift+Enter

**Vinodsralian** · 09-25-2010, 01:49 PM

Thanks Shg it solved my prob, but I would like to know, does small( ) function should itself handle. Any specific reason for small( ) not recognizing repeated nums.. just wanted to know !!