Forum Discussion
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:...
=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.