Current Events > Using excel be like

(+) Yeah! (+)

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


---

I've never used a filter formula ever. I would just use a vlookup in its place lol
---

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

---

Imagine using excel to store data

---

Here I am being a luddite and making my grocery lists with pen and paper

---

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...

---

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

Excel be like;

Imma vlookup(H0,2F:RN)

---

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.

---

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?

---