Need a formula/function to auto select MIN value from selected range.

Hi Guys!

I need a formula in attached file. in Cell B14 i have insert formula

=SMALL(B3:B10,1)

but it shows in one cell. I need a formula which will show less than 35% from the range B3:B10 multiple values in table.

Hope you guys understand.

With If in formula


Kind regards
Leo

ohh! Thank soooooo much.

Leo thank you so much for helping me. formula working best as i want it. but in next column i want to show name of that selected value i am using vlookup and index match. if i have

A B
1 Brown 50
2 Red 50
3 XYZ

your formula selecting both 50 value but my vlookup and index match formula selecting Brown only.

-2 represents to?

if i have no data in cell b than its showing error

Thanks for guidance actually JeteM's formula working perfectly. I am talking about this formula

Please Login or Register  to view this content.

this formula also working fine but if A did not sell any product and his income cell is blank, than above mentioned formula show his performance within the range which i gave less than or equal to 35% something like <=35%&blank. Hope you guys understand.

I propose a way to solve the problem using the AGGREGATE function.

thank you so much it works now the problem is in next column C where names will be showing according to B column. if i have more than two blank cells C column shows same name in both cells.

Try this in C14:
=IF(B14="","",INDEX(A$3:A$10,SMALL(IF($B$3:$B$10=B14,ROW($B$3:$B$10)-2,""),COUNTIF($B$14:B14,B14))))
Enter with Ctrl+Shift+Enter

thank you finally done. Thank you all dear....

Modified formula from Czeslaw:

=IFERROR(AGGREGATE(15,6,B$3:B$10/(B$3:B$10<=E$4)/(B$3:B$10<>""),ROW(1:1)),"")

If your question had been addressed, please mark thread as solved ("Thread Tools" at top of first post)