I have a more than 10k rows with date time values and would like to filter them by date.
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))
I have a more than 10k rows with date time values and would like to filter them by date.
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))