Forum Discussion

NV's avatar
NV
Copper Contributor
Nov 29, 2022

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

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.

Resources