132 reputation
1113
bio website
location California
age 35
visits member for 2 years, 6 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...


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?
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
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
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
Jun
20
comment How can I get a list of fields AND respective tables used in an MS Access 2010 database?
Thanks Remou for the other options
Jun
18
comment How can I get a list of fields AND respective tables used in an MS Access 2010 database?
I took out the default "Option Compare Database" line at the top and now it works. Thank you!
Jun
18
comment How can I get a list of fields AND respective tables used in an MS Access 2010 database?
I copied and pasted your edited code and it still errored out on the same Debug line
Jun
18
comment How can I get a list of fields AND respective tables used in an MS Access 2010 database?
Thanks for providing this VBA. But I tried running it and got an error on the Debug line. Was I suppose to modify something prior to running it? I see the first parm in Left function is "tbl_Name" and don't see where that is defined. Am I suppose to overwrite that and then this really only works with one table at a time?
Jun
18
comment How do I convert Windows Explorer file path to required file path format in R?
@nhinkle thank you!
Jun
14
comment How do I convert Windows Explorer file path to required file path format in R?
But how am I off topic when what I was asking for was a function not someone to edit my code? Its the same as other posts that exist out there and they were not closed. Examples: 1. Example1 2.Example2.
Jun
14
comment How do I convert Windows Explorer file path to required file path format in R?
maybe I shoudl have stripped of the examples to make it more generic looking?
Jun
14
comment How do I convert Windows Explorer file path to required file path format in R?
@Silva thanks for the earlier edit suggestion. I copied and pasted what you wrote and got: Error: '\C' is an unrecognized escape in character string starting "G:\C"
Jun
14
comment How can I get a list of fields AND respective tables used in an MS Access 2010 database?
SQL solution is preferred but if that's not possible then VBA will do. The database documenter is what I use today (with options set to a minimum). But I was hoping to have it in tabular form (less noise) similar to when I pull from MSysObjects (as shown in my example).