I have an equation
=INDEX($E$6:$E$42184, SMALL(IF(ISNUMBER(MATCH($Q$6:$Q$42184,$W$2, 0)), MATCH(ROW($Q$6:$Q$42184), ROW($Q$6:$Q$42184)), ""), ROWS($A$1:A1)))
It gives a date and time. E is a list of date and times, Q is a simple 1 or 0. very simple. W2 is 1.
I look down and it has
What i would like to do it only capture one value. So 9/1/20 3:56am then skip till 9/21/20 1:33pm then 9/1/20 7:34pm. Is there a way to modify this equation to do that.
=INDEX($E$6:$E$42184, SMALL(IF(ISNUMBER(MATCH($Q$6:$Q$42184,$W$2, 0)), MATCH(ROW($Q$6:$Q$42184), ROW($Q$6:$Q$42184)), ""), ROWS($A$1:A1)))
It gives a date and time. E is a list of date and times, Q is a simple 1 or 0. very simple. W2 is 1.
I look down and it has
9/1/20 3:56:00 AM |
9/1/20 4:04:00 AM |
9/1/20 4:14:00 AM |
9/1/20 1:33:00 PM |
9/1/20 1:41:00 PM |
9/1/20 7:34:00 PM |