Hi, I have a datalog spread sheet that has data recorded from a SCADA at 1 second and another that is at 1 minute intervals and need to align the two.
So, I'm trying to filter the 1 second records to only show those that are at 13 seconds past the minute. (as that's the timing for the second set of records at 1 minute intervals - if that make sense?).
I've been trying to use:
=MOD(SECOND(B236),$D$1)=0 in cell D2 (and copied down), where D1 contains the number 13
See attached screen shot
But as you can see, it's returning true for every 13th row, where as I though it would return true for every row that shows 13 as the seconds in column B
So, I'm trying to filter the 1 second records to only show those that are at 13 seconds past the minute. (as that's the timing for the second set of records at 1 minute intervals - if that make sense?).
I've been trying to use:
=MOD(SECOND(B236),$D$1)=0 in cell D2 (and copied down), where D1 contains the number 13
See attached screen shot
But as you can see, it's returning true for every 13th row, where as I though it would return true for every row that shows 13 as the seconds in column B
