27 reputation
19
bio website
location California
age 34
visits member for 1 year, 10 months
seen Jan 6 at 22:48

Here to learn about R and data mining/predictive modeling. I am new to these topics but have a business and analytical background...


Jan
6
accepted PowerPivot Bar is grayed out
Dec
20
asked Calculating Annualized Turnover in Excel PowerPivot
Dec
20
answered PowerPivot Bar is grayed out
Dec
20
revised Calculating Annualized Turnover in a Pivot Table or PowerPivot
Expanded question
Dec
20
answered Calculating Annualized Turnover in a Pivot Table or PowerPivot
Dec
20
comment PowerPivot Bar is grayed out
I figured out how to create a new measure which is ultimately what I was trying to figure out how to do as a next step. But it feels like I ought to be able to do this from the ribbon. I can't. To add a new measure I have right click on the table name in the PowerPivot Field List window. Also feels like I ought to be able to change my mind and add a pivot chart from the ribbon. But again I can't. I have to go back to the linked PowerPivot data table. What am I missing here?
Dec
19
comment PowerPivot Bar is grayed out
But what if I want to add calculated measures?
Dec
19
asked PowerPivot Bar is grayed out
Dec
19
asked Calculating Annualized Turnover in a Pivot Table or PowerPivot
Sep
9
awarded  Editor
Sep
9
comment Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
You know I was wondering about that last scenario but didn't even think to press my luck and ask. Thanks again. Great job!
Sep
9
accepted Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
Sep
9
comment Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
Awesome that works! Please post this as an answer and I will accept it.
Sep
9
comment Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
BTW I tried CSE and using sumproduct and using a range instead but still didn't work: {=SUMPRODUCT(COUNTIF(A27:A27,search_items1))}
Sep
9
comment Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
will what I'm trying to do is for each cell (thus the single cell reference instead of a range) count number of instances for example cell A1 might have "LBNL" or "LBL" or both. In the case of the first two the formula should return 1 and in the case of the second 2. For me it only works for the first item in the name range. So it will count a cell with single text of "LBNL" but if it has "LBNL LBL" it will return 0 instead of 2. Are you sure its working for you? Does it return 2 for you in the latter example?
Sep
9
awarded  Commentator
Sep
9
comment Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
btw I am trying to avoid VBA if at all possible
Sep
9
asked Is there a way to use a name range as an array criteria for a sum(countif()) formula in Excel 2010
May
24
awarded  Notable Question
Apr
27
asked How do I export to CSV without decimals using MS Access 2010?