Ronderbecke
Board Regular
- Joined
- Oct 4, 2017
- Messages
- 73
I was trying to query every Nth row for a long time and was able to make it work using filter which is great, but I cannot seem to make it work based on another cell (similar to query where you say if col1 is not null) Here is the formula that works just fine:
=filter('Stephen Sharman'!D2:D, (MOD(ROW('Stephen Sharman'!D2:D)-Row('Stephen Sharman'!D2)+1,12)=1))
The issue I run into is making it not display anything if 'Stephen Sharman'!C1:C is blank. I tried:
=filter(IF('Stephen Sharman'!C1:C>0,'Stephen Sharman'!D2:D,""), (MOD(ROW('Stephen Sharman'!D2:D)-Row('Stephen Sharman'!D2)+1,12)=1))
and varios versions of referencing to C1:C but they all give the same message:
FILTER has mismatched range sizes. Expected row count: 1000. column count: 1. Actual row count: 999, column count: 1
Is there a way to make the offset of D2 to C1 and D14 to C13 etc work?
=filter('Stephen Sharman'!D2:D, (MOD(ROW('Stephen Sharman'!D2:D)-Row('Stephen Sharman'!D2)+1,12)=1))
The issue I run into is making it not display anything if 'Stephen Sharman'!C1:C is blank. I tried:
=filter(IF('Stephen Sharman'!C1:C>0,'Stephen Sharman'!D2:D,""), (MOD(ROW('Stephen Sharman'!D2:D)-Row('Stephen Sharman'!D2)+1,12)=1))
and varios versions of referencing to C1:C but they all give the same message:
FILTER has mismatched range sizes. Expected row count: 1000. column count: 1. Actual row count: 999, column count: 1
Is there a way to make the offset of D2 to C1 and D14 to C13 etc work?