0
422
ViewsKeep blank cells visible based on previous cell value (true/false) in Google Sheets
I am working with a product sheet exported from Shopify with over 1000+ products. I need to create a filter view of Published products, however, each product contains variants with only the parent cell having a value of True or False.
| Code | Type | Published |
|---|---|---|
| xyx-234 | Shirt | True |
| xyx-234 | ||
| xyx-234 | ||
| xyx-567 | Jumper | False |
| xyx-567 | ||
| xyx-567 | ||
| xyx-567 | ||
| xyx-567 | ||
| xyx-567 | ||
| xyx-890 | Jeans | True |
| xyx-890 | ||
| xyx-890 | ||
| xyx-234 |
Is there a way of keeping empty cells based on the value of the last non-empty cell. Or am I better to try fill the blank cell with the value from above?
·
Juan Pablo Isaza
1 answers
Answer question0
You can try:
=FILTER(A:C,MMULT(--(A:A=TRANSPOSE(FILTER(A:A,C:C=TRUE))),LEN(FILTER(A:A,C:C=TRUE))^0))
Edit:
For large amount of data better use MATCH:
=FILTER(Products!A:Z,MATCH(Products!A:A,FILTER(Products!A:A,Products!H:H=TRUE),0))
·
Juan Pablo Isaza
Report
Answer question