I have 3 columns. column A is my "lookup value", with multiples of the same value, column B is the date performed, column C is the data I need. Based on the look up value, Column A, I need the most recent date, column B (max) to give me data in column c. the date will change daily as new data comes in
Thank you for your help