Highest Since/Lowest Since question?

[abruno]

I am looking at some gallup polling data on Obama and want to create a formula that says, data point in column C is the Highest or Lowest since X data based on the value in Column C and the text in column A i.e "Obama's approval rating is the lowest since July 24-26 2014" I have a formula but its not very elegant... I think I'm missing a simple solution. (Data in Column C is almost 2000 lines long). Thank you

A B C
Date Disapproval Approval​

July 26-28 2014 54 40
July 25-27 2014 53 39​

​

 

[Luke M]

Hi abruno,

See attached. basic formula I used:
="Score is the highest since: "&INDEX(A2:A31,MATCH(LARGE(B2:B31,2),B2:B31,0))

 

[abruno]

Thank you, this is great. Is it possible to capture the same number i.e its the higest since it was either the same number or greater?

 

[ashish mehra]

Hi Abruno,

Use

=INDEX(A2:A31,MATCH(LARGE(B2:B31,1),B2:B31,0))

or

=INDEX(A2:A31,MATCH(MAX(B2:B31),B2:B31,0))

in Luke's sheet.

Regards,
AM