|
I have no real knowledge of Excel, but managed to hack this together: =IF((G9-J9+K9)<>0,"",(G9-J9+K9)) on the basis that the IF function works like this: =IF(test, "action if test is true", "action if test is false") It's supposed to check to see if (G9-J9+K9) is equal to 0, and if so, display nothing (not just 0 - important workaround for Google Forms) in the cell. If (G9-J9+K9) is not equal to zero, it's supposed to evaluate (G9-J9+K9). Can anyone see what's going wrong here? do it fucked around with this message at 03:02 on Feb 13, 2010 |
# ¿ Feb 13, 2010 02:28 |
|
|
# ¿ May 7, 2024 05:17 |
|
Great, thanks! I don't know where I found the <> operator, but it clearly wasn't the right one. Another hopefully quick question: We're importing a list of user-defined "team names" and want to find out how many times each team is mentioned in the column to determine how many members it has. I know of =COUNTIF, but that seems to require that you know what you're looking for like =COUNTIF(A1:A100,"Red team"). In this case, because there are over 1500 rows of different user-defined team names that aren't preset, it's hard to give COUNTIF any real criteria. Is there a function that will output something like "X mentioned 2 times" "Y mentioned 10 times"? do it fucked around with this message at 06:12 on Feb 13, 2010 |
# ¿ Feb 13, 2010 05:37 |
|
I have two lists of companies, I'd like to find out which companies are in column A that aren't in column B. MATCH() seems like overkill? How should I be doing this?
|
# ¿ Oct 19, 2011 20:49 |
|
I am trying to find out how many subscriptions were active during a given period. In Column A, I have the subscription start date, in Column B, the subscription end date. Using a list of weeks, I would like to determine how many subscriptions were active in that week. I've uploaded a sample here: http://cl.ly/3I040N1R0Z0Y1K463X1q . Because subscription XX11 started on 7/17 and ended 7/29, it was active in week 7/9-7/15, week 7/16-7/22, and week 7/23-7/29. Because subscription XY23 started 7/9 and ended 7/18, it was active in week 7/9-7/15 and week 7/16-7/22. The other weeks had no subscriptions active. Any help would be appreciated!
|
# ¿ Mar 27, 2012 01:26 |
|
Old James posted:
I'm also trying to figure out how I can determine which week of a calendar quarter a date is in. For example, code:
|
# ¿ Mar 27, 2012 21:56 |
|
|
# ¿ May 7, 2024 05:17 |
|
Old James posted:
code:
|
# ¿ Mar 28, 2012 13:32 |