Forum Discussion
GusDDA
Apr 30, 2022Copper Contributor
FILTER FUNCTION data with alternating rows dependent and independent values
I have data which I have tried to filter for all 4 rows but cannot do.
56 | 7 | 51 | 51 | PW | 8 | 56 | 9 | PW | 51 | 8 | 56 | 7 | 9 | 51 | 7W | 56 | 51 |
9 | 7W | 51 | 5W | H6 | 5W | 7 | 6 | 7 | 9 | 7W | 51 | 6 | 9 | 9 | 6 | 51 | 51 |
84 | 142 | 78 | 103 | 121 | 189 | 84 | 129 | 130 | 58 | 138 | 39 | 135 | 139 | 99 | 175 | 8 | 97 |
120 | 175 | 97 | 177 | 164 | 175 | 147 | 168 | 146 | 111 | 168 | 43 | 150 | 131 | 124 | 197 | 68 | 102 |
I have also tried to filter data in this layout and can succeed with filtering in paired rows but not all rows by using FILTER(......)+FILTER(......) which give VALUE! result
56 | 7 | 51 | 51 | PW | 8 | 56 | 9 | PW | 51 | 8 | 56 | 7 | 9 | 51 | 7W | 56 | 51 |
84 | 142 | 78 | 103 | 121 | 189 | 84 | 129 | 130 | 58 | 138 | 39 | 135 | 139 | 99 | 175 | 8 | 97 |
9 | 7W | 51 | 5W | H6 | 5W | 7 | 6 | 7 | 9 | 7W | 51 | 6 | 9 | 9 | 6 | 51 | 51 |
120 | 175 | 97 | 177 | 164 | 175 | 147 | 168 | 146 | 111 | 168 | 43 | 150 | 131 | 124 | 197 | 68 | 102 |
any help would be greatly appreciated: I may be using an inappropriate function but I like its simplicity compared to index match. But I will use whatever works. TIA.
No RepliesBe the first to reply