Thanks Haseeb, Sam, Don for the follow-ups.
Mainly I was just commenting on the post that didn't do what I thought it stated it did, for me.. so others could benefit from my misunderstanding :) Nice solutions all.. These formulas can be adapted by anyone needing the third largest/smallest, or fourth, etc., as well as a complete ranking like this. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Haseeb Avarakkan Sent: Sunday, December 04, 2011 3:17 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers Hello Asa R, Assume your numbers are in A:A, in B1 enter Unique_Numbers, B2 copy down... =SMALL(A:A,1+COUNTIF(A:A,"<="&MAX(B1,-9E300))) The above will give the unique numbers in Ascending Order, =LARGE(A:A,1+COUNTIF(A:A,">="&MIN(B1,9E300))) This above will give the numbers in Descending Order. ___________ HTH, Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
