Good morning,
I want to use the =SMALL function, but I need it to ignore all the negative numbers in my data.
I know that min would look like this =MIN(IF(D6:D12>0,D6:D12)) but in this case I need =SMALL.
Thanks for any help!
Good morning,
I want to use the =SMALL function, but I need it to ignore all the negative numbers in my data.
I know that min would look like this =MIN(IF(D6:D12>0,D6:D12)) but in this case I need =SMALL.
Thanks for any help!
Hi,
=SMALL(IF(D6:D12>0,D6:D12),2)
array entered: confirmed with control+shift+enter
=AGGREGATE(15,6,D6:D12/(D6:D12>0),2)
just enter.
The "red" number is the K number read by SMALL/AGGREGATE
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
You would use this, and enter it as an array formula with ctrl+shift+enter:
where 1 represents the "1st" smallest number. Adjust to suit your needs.Please Login or Register to view this content.
another option, non-array, FWIW
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks