CODEWITHSUNDEEP
excelexcel-formulaexcel-2010excel-2019
King
King

Reputation: 1

Excel fetch maximum() from column of values

I have tried all possible formulas I know to fetch maximum value where the available record date = current record date using both the index formula combined with the max function and likewise used vlookup but all to no avail. Below are the formulas.

=VLOOKUP(MAX(A2:A40), A2:C40, 0) , =INDEX(c2:C46,MATCH(MAX(a2:a40),a2:a40,0))

c2:c40 represents my amount column while a2:a40 represents my date column in the table while the current date = 5/12/2022

I have tried using if statements with max function and also used index()combined with match() and max() and vlooup/max()

Upvotes: 0

Views: 279

Answers (1)

David Leal
David Leal

Reputation: 6759

You can use the following:

=MAXIFS(C2:C40, A2:A40, DATE(2022,12,5))

Assuming the date of your sample is in dd/mm/yyyy format. Instead of DATE, you can refer to the corresponding cell with the date value.

Upvotes: 1

Related Questions