Google Spreadsheet Post #1349
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug 29, 2013
user amj05 (http://productforums.google.com/forum/?zx=2cathjan7ij1#!category-topic/docs/spreadsheets/zgI4vGlrwSo)
Count instances in an array if
If I have two columns that look like this:
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug 29, 2013
user amj05 (http://productforums.google.com/forum/?zx=2cathjan7ij1#!category-topic/docs/spreadsheets/zgI4vGlrwSo)
Count instances in an array if
If I have two columns that look like this:
| A | X, Y |
| B | Y |
| C | X, Z |
| B | X, Y, Z |
| D | Z |
| A | Y, Z |
| A | X, Y, Z |
Is there a formula to count the total number of times Y appears to the right of A (whether or not Y appears with anything else)? The only way I know involves way too many lines (especially since there will be more variables than in this example). Thank you!
----------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment