Forum Discussion

GusDDA's avatar
GusDDA
Copper Contributor
Apr 30, 2022

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.

5675151PW8569PW5185679517W5651
97W515WH65W76797W5169965151
841427810312118984129130581383913513999175897
120175971771641751471681461111684315013112419768102

 

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

5675151PW8569PW5185679517W5651
841427810312118984129130581383913513999175897
97W515WH65W76797W5169965151
120175971771641751471681461111684315013112419768102

 

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

Resources