LogFAQs > #936469691

Hmm, I'd like to make a list of everything in my pantry. *enters list*

But wouldn't it be good if any item with "0" was red? *adds conditional formatting*

Wouldn't it be good if any item with 0 populated a separate list so I know what to shop for? *add filter*

Wouldn't it be good if that shopping list could populate from several different columns at once? *adds arrays*

These line breaks are annoying though. *adds second condition*

[a day later]

So in summary, in order to create a shopping list, we need to say =FILTER({A2:A35;D2:D21;G2:G35},({B2:B35;E2:E21;H2:H35}=0) *({A2:A35;D2:D21;G2:G35}<>""))

Technology is so great, it really makes your life simple


---

CE's Resident Scotsman.
https://imgur.com/ILz2ZbV