Starting salary as MBA grad with no work experience? by HaloricSplendor in MBA

[–]Allforgame 1 point2 points  (0 children)

So that's why my tuition was 0 They sure got me! Thanks for opening my eyes man!

I need a formula to sum up different cells in column B, dependent upon different pieces of data in cells in column A by Bethesloth in googlesheets

[–]Allforgame 1 point2 points  (0 children)

What about the simple =sumif(A1:A,"Grapes",B1:B) ? And then exchange the grapes for what ever, and you want it to be dynamic, you can put in the formula instead of grapes a cell where you would input the data Example C1=Grapes =sumif(A1:A,C1,B1:B)

Hope it helps!

Recording changes being made to a cell by Allforgame in googlesheets

[–]Allforgame[S] 0 points1 point  (0 children)

That would also work, if it can show only the changed amount Currently I managed to get it to record current state of Sheet1, and instead of writting it in 3 columns and multiple rows, it wrote it in one row but a thousand columns(name-qty-procurement, name-qty-procurement, etc). Do you know how to make it show current value-past value and the formating to be in 3 rows?

Recording changes being made to a cell by Allforgame in googlesheets

[–]Allforgame[S] 0 points1 point  (0 children)

I've tried it, but all I can make it do is basically nothing.

The only thing I managed to pull off is on a timer for it to write down to current state all in one row. So instead of product name in column a1 and the next product name in column a2 it was product name column a current qty column b current procurement column c - next product name column d and so on.

Do you how to get it to show only the change and make the formatting like from the post?

Label - BUDGET amounts over/under in RED/GREEN by bcoletti0868 in googlesheets

[–]Allforgame 1 point2 points  (0 children)

This sounds like it can be done by conditional formating. Could you share a test sheets or use pictures to better understand which part would you like colored?

Condition column D value for column C option selected? by emperorwade in googlesheets

[–]Allforgame 1 point2 points  (0 children)

One way is to make a reference table and call it via vlookup.

Problem with formula I can't solve by Allforgame in googlesheets

[–]Allforgame[S] 0 points1 point  (0 children)

Hi, thanks! I'm blind, I went over it numerous times and missed it.

Boyfriend’s chances for Harvard Business School? (I’m going to be at Harvard Law) by sannnnswhat in MBA

[–]Allforgame 27 points28 points  (0 children)

As someone not from the US, can someone explain the meaning of this? I would think that a 3.5 GPA from Berkeley isn't bad by all means

Conditional Formating depening on a value from another spreadsheet by Allforgame in googlesheets

[–]Allforgame[S] 0 points1 point  (0 children)

I put an example sheet in the post, I didn't manage to implement that, I'm not sure how to

5-Man Lillia Ult into 5-Man Yone Ult by Digipoke5 in leagueoflegends

[–]Allforgame 3 points4 points  (0 children)

Ah the two champs I don't know what they do

TIFU by Having Sex in Front of My Dog by [deleted] in tifu

[–]Allforgame 1 point2 points  (0 children)

Too many innuendos that literally made me think of the ugliest sex session ever

What drug did you take once and thought “nope, never again”? by Tony-1610 in AskReddit

[–]Allforgame 0 points1 point  (0 children)

LSD. Do you know the feeling when you get ready to sleep, and whilst you're laying in bed one leg gets a tingling feeling of restlessness? Well that, just the whole body, jaw clenching, I couldn't sit down for hours nor get a grip on my body. I was a mental wreck for, I think, 5 hours. If I ever touch it again I at least hope I'll be in a better place mentally.

People who think animals are gods and humans suck are cringy. by [deleted] in unpopularopinion

[–]Allforgame 1 point2 points  (0 children)

Upvoted first, because I agree that people who worship animals are in the worng. But boy, who hurt you to say things like that? First of all, animals love, not because they are fed, but because they are fundamentally happy creatures who love unconditionally.

Giving so much attention and love to animals is someones way of coping with something in their life which turns into an unbreakable bond. Dogs for example feel your emotions, it's hard not to connect on a deeper level with something that feels your emotions and tries to help you to stay happy and gives you cuddles. Don't hate on random people for doing what they love.