look up and display last max value in a column

		Microsoft Office Forums > Microsoft Excel > Excel
look up and display last max value in a column

01-10-2024, 06:35 PM

p45cal

Windows 10 look up and display last max value in a column

Office 2021

Expert

Join Date: Apr 2014

Posts: 963

Quote:

Originally Posted by oscarlimerick

I dont really want to check row wise, I want to check by the date

Try array-entering in cell G5:

Code:

=MAX(IF(((A5:A1000<INDEX(A5:A1000,MATCH(MAX(A5:A1000),A5:A1000,0)))*(B5:B1000>INDEX(B5:B1000,MATCH(MAX(A5:A1000),A5:A1000,0)))),A5:A1000))

and in cell E5:

Code:

=INDEX(B5:B1000,MATCH(G5,A5:A1000,0))

No dates with with no score.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display of predecessor and successor column	tropaj	Project	3	04-03-2022 04:12 PM
display a change in column cells counting the number of months	oscarlimerick	Excel	4	03-14-2022 12:22 AM
Display an additional date column in Gantt chart	ds1	Project	4	04-17-2017 01:34 PM
Embedded Excel in Powerpoint - custom animation, display column by column	andytheanimal	PowerPoint	2	01-20-2015 06:30 AM
Excel Fomula to search for a string and display value from different column	zeeshanbutt	Excel	1	07-29-2012 12:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:20 AM.