SMALL

SMALL

 

With the help of Small Function in excel, we find nth smallest value- 1st smallest value, 2nd smallest value, 3rd smallest value from a range, etc.

Small Function की मदद से हम कि किसी range से 1st , 2nd, 3rd  या इस तरह smallest की वैल्यू पाते हैं.

Syntax

=SMALL (array, k)

array —> Range from we want nth value.

k—>k tells Excel to return the nth-smallest value.

 

 

 

 

 

 

 

 

Click Here For Download File for Small Function