Finding an returning largest values and keeping sign

[katieconn]

I am trying to create a variance explanation formula by creating a formula that says "Over Budget <pulls the largest number positive or negative> <corresponding account name for that number> and <pulled second-largest positive or negative number> and <corresponding account name for that number>. I am using this formula to pull the largest number but not sure how to pull the second largest while ignoring the first largest. =CHOOSE(MATCH(MAX(ABS(K31:K43)),ABS(K31:K43),0),K31,K32,K33,K34,K35,K36,K37,K38,K39,K40,K41,K42,K43)

 

[katieconn]

I think i figured out a solution. Using Large instead of Max you can specify 1st largest then 2nd largest, etc