model

Hi Experts.... I don't want other users to be able to see my DAX formulas... So, could you please tell me VBA code to PASSWORD PROTECT from users opening Data model window. Thanks in advance

The Input Values to be entered ..IN F2 & F4. The Value in F2 needs to be searched in the array G14:K19 AND the value Entered in F4 needs to be searched in the array L14:P19. If both the values are found on the same Row and corresponding columns , We need the corresponding Model to be returned...

I have a userform with a combo box where you can select various models of valves. Depending on what model you select I would like another combo box to appear which is linked to a named range. There are 6 different model number to chose from so I need 6 different combo boxes to appear & 1 free...

I need help creating a dashboard that contains 3 Comboboxs that then cascades through selection down to the resulting machines test results. EX: Bulldozer > John Deere > 750K or Excavator > CAT > D264 My excel workbook is comprised of Multiple sheets for every type of construction machine...

Hello, I have a spreadsheet where I'm wanting to input the "Make", "Model", "Mast Type" and "Lift Height" and from this information, look up data in another tab and insert into my first sheet but with there being multiple criteria, I'm struggling to work it out. For example, with the "Engine...

Hi, I want to find coefficiences in Multiple regression model with dependent variable Y and 4 independent variable X1, X2, X3, X4 by VBA. I am a newbie to VBA, so any assistance would be appreciated. Thank you

Hi Guys, Appreciate if somebody can help me correct below formula...

Hi, I just want to know if anybody have built a MRP model using Power Pivot. Basically the inputs for the MRP model are initial stock, consumption (sales & bill of materials), up coming purchase order and final inventory. Thanks

i recorded a macro that create a pivot table but the change i make with manage data model are not recorded, so i have to make changes in data model manually in powerpivot manage data model, then again i recorded the rest of what a pivot table does. so i want a way to make changes in data model...

Hello! I have two columns: [*=1]X ranging from 300 to 1050 (cells AB53:AB803) [*=1]Gaussian Model I would like the Gaussian Model column to fill in with Gaussian values. Not sure if this makes any sense. Here is a somewhat basic example of what I mean. Example: I want to generate...

Hello, I am working on a project that will be looking at a datasource and trying to match up Model ID's onto another sheet in the same workbook and then copying over the Model Name if it finds the value. If not, it will look to the lastrow of the 2nd sheet and add the New Model ID and Model...

Hi all, In A2:A32, I have a list of Toyota vehicle names. In subsequent columns from B:S, I have model years. Each vehicle name does not have the same quantity of model years, some have only 1 other have 11. My question is this: A2 (Camry) has 4 model years (B2: E2) to the right of it. In Z2:Z5...

<tbody> comments serial no. model no. part no date serial :1235468 model: III-5400 part :tab3gd1 D:05/08/2018 56788 III-555 gac56r1 05/08/2018 </tbody> Hi All, Please I need help in this matter. I have over than 300 rows. and I have a column of comments with data in each...

All, I'm beginning to draw up the plans for a budget model I need to build in about a month and am stuck on a rather large piece of it. Hoping to get your best practice guidance as I'm sure many of you have run through similar projects in the past. Ultimately, I will be holding the full...

Hello, I would like to be able to write a macro that looks for duplicates across "Models". What I mean by this specifically is that, there are certain properties that can exist within our products that must of necessity only occur once. However, due to a different concept of what constitutes a...

RE: Count if Hi All I need some help if you dont mind, I have a sheet called "Detailed NTWK (LAN) HW Status, and on there is two columns: - F3:F60 - Core Switch Model - This is a drop down box for selection G3:G60 -Core Switch Quantity - This is a drop down box for selection H3-H60 -...

Hi All I need some help with a formula if you dont mind.... Bascially I have a Sheet called "Detailed NTWK (LAN) HW Status" and within that a column called "Core Switch Model" (Cell F3:F60), next to that there is a "Core Switch Quantity"(G3:G60). Both of these columns have data validation list...

Hi, I need help with this, I am stuck. I have this formula: =IF(AF2<>0;IF(AND(ISNUMBER(SEARCH(INDIRECT("'"&"Bestseller spec"&"'!"&"P"&AF2);Indata!P2));ISNUMBER(SEARCH(INDIRECT("'"&"Bestseller spec"&"'!"&"Q"&AF2);Indata!P2));ISNUMBER(SEARCH(INDIRECT("'"&"Bestseller...

We add to Excel Data Model using Ctrl T or first change the data to Data Table first. However we lose some flexibility once the data is turned into the Excel Table. Is there a way to add a named range instead of a Data Table into Data Model ? I do not have PowerPivot but instead Excel 2016 so I...