I have attempted to extract the 1st and 2nd minimum numbers from the same column. Can do the first with MIN() but I cannot solve for the 2nd min. and output into separate cells.
Excel 2000
Example:
Column A1:A6 with nums 3,4,4,5,6,4, 3 and 4 into cells A7 and A8
Column B1:B6 with nums 4,3,6,6,3,4 3 and 3 into cells B7 and B8
Any help would be appreciated.
Bob
Try this one.
a7=small(a1:a6,1)
a8=small(a1:a6,2)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
That works great. Your language may not be English but you are quite fluent in Excel. Thank you for the help.
Thanks for the reply (and compliment).
Glad i could help.
If your question is solved, will you mark it as solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks