Feb 23 2022 01:44 PM
Hello -
I'm attempting to find every 8th value in a column of values that exceeds a numeric threshold. Any tips on functions to use would be appreciated.
Feb 23 2022 03:08 PM
With 365 you could use
= LET(
filtered, FILTER(value, value>=100),
required, QUOTIENT(COUNT(filtered),8),
idx, SEQUENCE(required,1,1,8),
INDEX(filtered, idx)
)
This filters your original column of values, builds a sequence that is of the correct length and increments in 8s, and finally returns the required values by index.