CODEWITHSUNDEEP
dategoogle-sheetsfiltermaxmin
mau
mau

Reputation: 195

Values between a date Google sheets

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

Upvotes: 1

Views: 31

Answers (1)

player0
player0

Reputation: 1

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))

Upvotes: 1

Related Questions