Page 1 of 1 |
|
Posted: Mon, 24th May 2010 12:06 Post subject: Excel... |
|
 |
|
|
Back to top |
|
 |
|
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. |
|
|
Back to top |
|
 |
LeoNatan
Banned
Posts: 73193
Location: Ramat Gan, Israel 🇮🇱
|
Posted: Mon, 24th May 2010 14:43 Post subject: |
|
 |
You can use
=COUNTIF(B2:B4, "firm1")
=COUNTIF(B2:B4, "firm2")
It counts the number of times "firm1" appears between B2 and B4.
|
|
Back to top |
|
 |
Werelds
Special Little Man
Posts: 15098
Location: 0100111001001100
|
Posted: Mon, 24th May 2010 14:50 Post subject: |
|
 |
|
|
Back to top |
|
 |
|
Posted: Mon, 24th May 2010 15:26 Post subject: |
|
 |
Leo is right although I would throw in a pull-down list with data validation in the variable field to avoid any input errors.
|
|
Back to top |
|
 |
|
|
Back to top |
|
 |
LeoNatan
Banned
Posts: 73193
Location: Ramat Gan, Israel 🇮🇱
|
Posted: Mon, 24th May 2010 18:50 Post subject: |
|
 |
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. 
|
|
Back to top |
|
 |
|
Posted: Mon, 24th May 2010 19:35 Post subject: |
|
 |
|
|
Back to top |
|
 |
|
Posted: Mon, 24th May 2010 23:18 Post subject: |
|
 |
Why would you use excel as a physicist?
|
|
Back to top |
|
 |
|
Posted: Tue, 25th May 2010 00:25 Post subject: |
|
 |
Well, some people excel as physicists.
|
|
Back to top |
|
 |
|
Posted: Tue, 25th May 2010 00:43 Post subject: |
|
 |
|
|
Back to top |
|
 |
ixigia
[Moderator] Consigliere
Posts: 64926
Location: Italy
|
|
Back to top |
|
 |
LeoNatan
Banned
Posts: 73193
Location: Ramat Gan, Israel 🇮🇱
|
Posted: Tue, 25th May 2010 00:54 Post subject: |
|
 |
|
|
Back to top |
|
 |
Werelds
Special Little Man
Posts: 15098
Location: 0100111001001100
|
|
Back to top |
|
 |
Page 1 of 1 |
All times are GMT + 1 Hour |