Find Max number from a date range and print in the next cell

Copper Contributor

In the attached excel sheet, i have a number "series" with date and time. I need to print the date-wise maximum number from "series" column, in the corresponding next cell in "Max no" column. For ex: If we look at the "Series" data of 24-10-22, 7062 is the maximum number. The same is printed at D56. similarly i need to print the same for rest of the dates, kindly help. Thanks in advance.

1 Reply

@NV 

=LARGE(IF($A$2:$A$20553=A2,$C$2:$C$20553),1)

You can try this formula in cell D2. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021 and fill the formula down.

max number.JPG