NFOHump.com :: View topic

Page 1 of 1

dingo_d
VIP Member

Posts: 14555

Posted: Mon, 24th May 2010 12:06 Post subject: Excel...	Quick Quote Quote

I really didn't know where to put this, but hey wth I have excel table that looks like this: So I want (or better yet, need) the formula that, when I change the firm of person1 for ex. so that he works in firm2 and not firm1 , will automatically change the number of people working in that firm in the B field under no. Of employees. I haven't touched excel since high school, and even there we didn't do shit in excel

Profile
PM

dingo_d
VIP Member

Posts: 14555

Posted: Mon, 24th May 2010 14:35 Post subject:

Anyone?

"Quantum mechanics is actually, contrary to it's reputation, unbeliveably simple, once you take the physics out."
Scott Aaronson

chiv wrote:

thats true you know. newton didnt discover gravity. the apple told him about it, and then he killed it. the core was never found.

Profile
PM

LeoNatan
Banned

Posts: 73193
Location: Ramat Gan, Israel 🇮🇱

Posted: Mon, 24th May 2010 14:43 Post subject:	Quick Quote Quote

You can use =COUNTIF(B2:B4, "firm1") =COUNTIF(B2:B4, "firm2") It counts the number of times "firm1" appears between B2 and B4. My IMDb Ratings \| Fix NFOHump Cookies \| Hide Users / Threads \| Embedded Content (Videos/GIFs/Twitter/Reddit) \| The Derps Collection Death smiles at us all; all we can do is smile back.

Werelds
Special Little Man

Posts: 15098
Location: 0100111001001100

Posted: Mon, 24th May 2010 14:50 Post subject:	Quick Quote Quote

http://tinyurl.com/38fnacy Join in on the war on LeoSatan

Profile
PM

swingman

Posts: 3602

Posted: Mon, 24th May 2010 15:26 Post subject:	Quick Quote Quote

Leo is right although I would throw in a pull-down list with data validation in the variable field to avoid any input errors.

Profile
PM

dingo_d
VIP Member

Posts: 14555

Posted: Mon, 24th May 2010 18:33 Post subject:

swingman wrote:

Leo is right although I would throw in a pull-down list with data validation in the variable field to avoid any input errors.

Great! Now translate that so I can use it grinhurt

EDIT: That thing Leo said works! Thnx ^^

Profile
PM

LeoNatan
Banned

Posts: 73193
Location: Ramat Gan, Israel 🇮🇱

Posted: Mon, 24th May 2010 18:50 Post subject:	Quick Quote Quote

What you can do is add data validation to the fields to allow only "firm1" or "firm2" as valid values. This way it will not allow you to put "firm 1" by mistake and then wonder why calculations are not correct. My IMDb Ratings \| Fix NFOHump Cookies \| Hide Users / Threads \| Embedded Content (Videos/GIFs/Twitter/Reddit) \| The Derps Collection Death smiles at us all; all we can do is smile back.

swingman

Posts: 3602

Posted: Mon, 24th May 2010 19:35 Post subject:

dingo_d wrote:

swingman wrote:

Leo is right although I would throw in a pull-down list with data validation in the variable field to avoid any input errors.

Great! Now translate that so I can use it grinhurt

Iamdisappoint.jpg Sad

You're supposed to be the resident physicist/evil-genius! That's the problem with the stupid 'ribbon' in MS Office these days. A large percentage of the people don't even see the rest of the program other than the default tab.

Anyway, if you click on the 'Data' tab and then 'Data-validation' then you should be able to see the relevant options. I would suggest making a list of the firms you would like to be able to choose from somewhere on your sheet. Then under data-validation select the option 'list' and you should be able to figure out the rest. Or pwerelds can always help you out with his lmgtfy links. Razz

http://live.lmgtfy.com/

Profile
PM

Atropa

Posts: 878

Posted: Mon, 24th May 2010 23:18 Post subject:	Quick Quote Quote

Why would you use excel as a physicist?

Profile
PM

VGAdeadcafe

Posts: 22230
Location: ★ ಠ_ಠ ★

Posted: Tue, 25th May 2010 00:25 Post subject:	Quick Quote Quote

Well, some people excel as physicists.

Profile
PM

Atropa

Posts: 878

Posted: Tue, 25th May 2010 00:43 Post subject:	Quick Quote Quote

badum dish..

Profile
PM

ixigia
[Moderator] Consigliere

Posts: 64926
Location: Italy

Posted: Tue, 25th May 2010 00:46 Post subject:

@swingman
I took a look at your suggestion and

Spoiler:

Random creations of an insane mind / Screens from Bulgaria [Early Access]

Profile
PM

LeoNatan
Banned

Posts: 73193
Location: Ramat Gan, Israel 🇮🇱

Posted: Tue, 25th May 2010 00:54 Post subject:	Quick Quote Quote

My IMDb Ratings \| Fix NFOHump Cookies \| Hide Users / Threads \| Embedded Content (Videos/GIFs/Twitter/Reddit) \| The Derps Collection Death smiles at us all; all we can do is smile back.

Werelds
Special Little Man

Posts: 15098
Location: 0100111001001100

Posted: Tue, 25th May 2010 09:49 Post subject:

swingman wrote:

Or pwerelds can always help you out with his lmgtfy links. Razz

Well it's so easy, took me literally about 30 seconds to get the correct answer with a step by step explanation

Profile
PM

Page 1 of 1

All times are GMT + 1 Hour