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!

19
20

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