Topic List |
Page List:
1 |
---|---|
pinky0926 03/30/20 6:52:01 AM #1: |
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 ... Copied to Clipboard!
|
Smashingpmkns 03/30/20 7:01:08 AM #2: |
I've never used a filter formula ever. I would just use a vlookup in its place lol
--- Clean Butt Crew ... Copied to Clipboard!
|
Romulox28 03/30/20 7:42:15 AM #3: |
for me its more like:
me: hmmm id better make a grocery store list *2hrs later* me: oops, this entire spreadsheet is now driven by 1,200 character Index Matches --- ... Copied to Clipboard!
|
Rika_Furude 03/30/20 7:43:19 AM #4: |
Imagine using excel to store data
--- ... Copied to Clipboard!
|
agoatthief 03/30/20 7:43:46 AM #5: |
Here I am being a luddite and making my grocery lists with pen and paper
--- *steals your goats* ... Copied to Clipboard!
|
DevsBro 03/30/20 8:30:23 AM #6: |
Hm, let me make a list of everything in the pantry...
(Five hours later) So if I were to make a Mega Man minigame collection, this is the order I would release characters in in order to cover each archetpye as quickly as possible while also prioritizing plot important characters and fortress bosses, and minimizing the amount of custom spritework I would have to do. Now about that grocery list... --- 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 53 ... Copied to Clipboard!
|
ZevLoveDOOM 03/30/20 8:32:59 AM #7: |
well it can be annoying to use when you have to type those functions and stuff but im honestly used to it at this point. lol
... Copied to Clipboard!
|
divot1338 03/30/20 9:54:36 AM #8: |
Excel be like;
Imma vlookup(H0,2F:RN) --- Moustache twirling villian https://i.imgur.com/U3lt3H4.jpg- Kerbey ... Copied to Clipboard!
|
Squall28 03/30/20 10:04:31 AM #9: |
eh that's on you. In order to create a shopping list, all you need to do is write an item down when you are low, and take it off when you replenished it. The real work here is that you are going to have to keep tabs on the quantity of stuff you have.
--- If you're going through hell, keep going. -Winston Churchill ... Copied to Clipboard!
|
pinky0926 03/30/20 10:13:50 AM #10: |
Squall28 posted...
eh that's on you. In order to create a shopping list, all you need to do is write an item down when you are low, and take it off when you replenished it. The real work here is that you are going to have to keep tabs on the quantity of stuff you have. Why do something thesimple age old tried and tested way, when you can do it the new-age application overengineered more trouble than its worth way? --- CE's Resident Scotsman. https://imgur.com/ILz2ZbV ... Copied to Clipboard!
|
Topic List |
Page List:
1 |