Small function

[alliswell]

Hi everybody

May i know, why excel small function shows only 10 small values. If thats the limit then what if i need more smallest values.

Thanks & Regards

 

[Fluff]

What exactly do you mean? Can you post some sample data showing what you are trying to do.

 

[alliswell]

What exactly do you mean? Can you post some sample data showing what you are trying to do.

Oh fluff thanks you are here,
How are you ?

Fluff i have some values in B column may be approx 500, i want to get 50 smallest values from them, but when i use combination of small with rows function it shows only list of 10 small values.

I used this formula in D1
=SMALL(B2:B52,ROWS(B$2:B2)) but it gave me only 10 small values

 

[Fluff]

You need to anchor the range like

=SMALL($B$2:$B$52,ROWS(B$2:B2))

 

[alliswell]

You need to anchor the range like

=SMALL($B$2:$B$52,ROWS(B$2:B2))

Thanks fluff. You are such a sweetheart bro.

Take care. Love you bro

 

[Fluff]

You're welcome & thanks for the feedback.

 

[alliswell]

You're welcome & thanks for the feedback.

Fluff can you help me by providing some sites that may give detailed and in depth ideas & tricks in using nested functions or combined formulas and also detailed formulas tips

 

[Fluff]

I'm afraid not, most of what I've learnt is from here.