Looking for Value in Another Column, Evaluating and Then Looking in Another Column

**olives** · 02-16-2013, 08:20 AM

I'm half asleep, but, does this formula do what the original did? If I paste it below the 1st time will it give me the 2nd best, or highest, value?....

**Rick Rothstein** · 02-16-2013, 08:39 AM

Originally Posted by olives

I'm half asleep, but, does this formula do what the original did? If I paste it below the 1st time will it give me the 2nd best, or highest, value?....

Remember I said "The first instance of this UDF must be placed on the same row as the first (topmost) number in your two columns of numbers"... the reason is the formula needs a starting point to calculate from, so I used the top row of the two columns of numbers. From there, you can copy the formula down as far as you like. So, the highest value will be on the same row as the top cell of the two columns of numbers, the second highest will be under that one and so on.

**olives** · 02-17-2013, 11:25 PM

Originally Posted by Rick Rothstein

... I said "The first instance of this UDF must be placed on the same row as the first (topmost) number in your two columns of numbers"... the reason is the formula needs a starting point to calculate from, so I used the top row of the two columns of numbers. From there, you can copy the formula down as far as you like. So, the highest value will be on the same row as the top cell of the two columns of numbers, the second highest will be under that one and so on.

I hadn't read the above before sending out my last message, but yes, I have them lined up as you have described.