Friday, November 2, 2012

yogi_Identify N Smallest Numbers From A List And Flag Them With a Specified Character


                                           Google Spreadsheet   Post  #848
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 02, 2012
user pfdusa said: (http://productforums.google.com/forum/?zx=gdxpen6jynp#!category-topic/docs/spreadsheets/xwMVgW0JNRI)
find 10 smallest numbers in column
Hello,

I have a spreadsheet with 20 numbers. I want to find the 10 smallest and put a "*" or something next to them. 

Any help would be appreciated.

Thanks,
Paul

20.792
22.6
26.0503816793893
22.6
26.1487603305785
26.3355371900826
16.2609756097561
20.014406779661
19.888
24.408
21.6661157024793
15.1289256198347
24.5541353383459
9.93030303030302
30.736
27.2694214876033
22.515671641791
37.064
20.6862903225806
23.969696969697
---------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem based on my understanding of what the user wants