finding 10 smallest numbers from last 20 input
Hello,
Select cells AD4:AD13 and array-enter:
=SMALL(IF(INDEX(AB:AB,MAX(1,COUNT(AB:AB)-19)):INDEX(AB:AB,COUNT(AB:AB))<0,INDEX(AB:AB,MAX( 1,COUNT(AB:AB)-19)):INDEX(AB:AB,COUNT(AB:AB))),ROW(INDIRECT("1:10 ")))
Personally I would favor a small UDF for this, but you posted this
question in Excel.Worksheet.Functions...
Regards,
Bernd
|