LinkBack URL
About LinkBacks
hi
in any formula index with small
if small give me 10 numbers .... how i get just 3 not all when i Drag down
=index(a1:a100;small( ................................. ..;I need here just three smallest not all 10)
hi
in any formula index with small
if small give me 10 numbers .... how i get just 3 not all when i Drag down
=index(a1:a100;small( ................................. ..;I need here just three smallest not all 10)
Maybe
=INDEX(A1:A100,SMALL(....,ROWS(INDIRECT("1:"&ROW(A1:A100))))
drag down for 3 rows
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
thanks Special-K
but when i drag more than 3 it gives me value .... how in formula get 3 smallest from 10 values..... not all???
=IFERROR(INDEX(A1:A100,SMALL(....,ROWS(INDIRECT("1:"&ROW(A1:A100)))),"")
or
=IF(ROWS(INDIRECT("1:"&ROW(A1:A100)))>3,"",INDEX(A1:A100,SMALL(....,ROWS(INDIRECT("1:"&ROW(A1:A100))))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks