Home > OS >  Values between a date Google sheets
Values between a date Google sheets

Time:04-22

I have a more than 10k rows with date time values and would like to filter them by date.

Like the example below enter image description here

CodePudding user response:

use:

=FILTER(A:A; INT(A:A)=C2)

min:

=MIN(FILTER(A:A; INT(A:A)=C2))

max:

=MAX(FILTER(A:A; INT(A:A)=C2))
  • Related