Forum Discussion

Sanjyn81's avatar
Sanjyn81
Copper Contributor
Dec 09, 2023

Autofill large increment

Hello I have two questions regarding the same spreadsheet. Let me make a small example first:   A                                        B                       C                         D        ...
excel
Formulas and Functions
Harun24HR's avatar
Harun24HR
Bronze Contributor
Dec 09, 2023

Sanjyn81 You can try MAXIFS() with date+time comparison.

 

=MAXIFS(B:B,A:A,">="&C1+TIME(0,0,0),A:A,"<="&C1+TIME(23,59,59))

 

Then try FILTER(), and SORT().

 

=@SORT(FILTER(A:B,(A:A>=C1+TIME(0,0,0))*(A:A<=C1+TIME(23,59,59))),2,-1)

 

 

 

Resources