LinkBack URL
About LinkBacks
I'd like to return the two lowest values from an array of numbers. Is there a way to tweak the MIN function to do this?
Example: For the array below, I want to be able to return 0 & 1.
1,2,4,3,6,0
Thanks!
I'd like to return the two lowest values from an array of numbers. Is there a way to tweak the MIN function to do this?
Example: For the array below, I want to be able to return 0 & 1.
1,2,4,3,6,0
Thanks!
Here is the formula to find the 1st and second lowest value
=SMALL($A$1:$A$10,1)
=SMALL($A$1:$A$10,2)
if you want to put them together you can enter a formula like this
=SMALL(A1:A10,1)&" & "&SMALL(A1:A10,2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks