switch

  1. S

    Power BI Custom Subtotals

    Hi, I'd like to be able to create custom subtotals for say Total Revenue based on other values. I'm using the idea from the video linked below to do this using a SWITCH function. The irony is the normal values pull through okay, it's the [Total Rev] value that doesn't, which is strange as the...
  2. W

    Formula to measure length of pipeline within specific depth brackets

    Hi all, I am struggling with a formula on Excel and was hoping you could help me with this. I work for a construction company and one of the things we do is the installation of manholes and pipelines. We get paid a rate for pipelines between 0 and 1.5 meters deep. Then there is a separate rate...
  3. Y

    Userform UI Language Customization

    I have some userforms created in English, how do I code it such that using an option button, I can switch / change all the text to another language?
  4. M

    Switch

    I'm trying to learn some new formulas & have come across SWITCH. I know how to use VLOOKUPS I have a list of names of Fruit in Column A - in A1:A5 & a list of costs for each next to them in B1:B5 In D1 I want to type some fruit e.g. Apple, which is also in A3, the press Enter when I have...
  5. M

    VLookup on 3 Columns Formulae

    Good Morning Thanks for Reading I have two spreadsheets one called Switch Info and the other Database Master, I am looking from the Database Manager to the Switch Info Both Have three columns called Login (Column A), Device (Column B) and Numbers (Column C) First Formulae I need a lookup to...
  6. H

    Match The Switch & Grab The Value From A Range

    My Data Range is B2:G9 (contains values) with ‘headers’ in B1:G1 (Non -numeric) ‘switches’ are in B12:G12 which are EITHER 0 OR 1; AND at a time ONLY 1 ‘SWITCH‘ FOR ‘UNIQUE’ HEADER WILL HAVE 0 OR 1 ‘MATCHING SWITCH’ is in I1:L1 Output is required in I2:J9 as: MATCH THE SWITCH & ‘grab’ the...
  7. N

    SUMIFS between two dates noted in cells

    Is there a way to switch it so that instead of listing the dates in the SUMIFS formula [ =SUMIFS($F:$F,$A:$A,">=1/1/19",$A:$A,"<=1/26/19") ] when totaling the value between two dates to make it so I can put the beginning and end dates in cells and having the formula refer to the cells? It gives...
  8. wadergirl

    Macro to open another program - shortcut target has a command line switch

    So, in my spreadsheet, I have an existing macro that uses: Shell ("C:\Program Files (x86)\Google\Chrome\Application\chrome.exe") So I'm pretty sure that it is the base of what I need to use for this other program, but the other program I need to use a shortcut which has a command line switch...
  9. B

    Pivot Tables - Locking the Chart Type and Formats

    Hello, I created a pivot table that is being linked to a slicer. My slicer allows me to switch the data being presented by different views. However, when I switch around, my pivot charts keep changing the chart type (i.e. my intention is to have a combo chart, but it keeps switching to a bar...
  10. F

    Need code to switch between application

    Hi all, So I m using Excel VBA. I need code to switch between Non Excel program and copy their information for my Excel spreadsheet It could be MS apps, Chrome or some old app like Command Prompt Please help !
  11. S

    "there's a problem with the clipboard, but you can still past this content within this workbook " error

    I know this is old news, but maybe someone knows a workaround for this error. I copy and paste up to 10,000 entries to an external program. I have reinstalled and tried every fix I've seen on the web. I simply cannot use excel with this error. I have had to switch over Open Office and it works...
  12. V

    Excel Switch Between Workbooks

    Hi, Is it possible to get a macro to switch from current workbook, to previous workbook in code, similar to what 'Alt + Tab' does ? Thanks for any assistance !
  13. M

    Custom views

    Workbook has no tables and no protected sheets. Have created several custom views but excel does not successfully switch between them e.g. view “males only” works. Switch view to show people from e.g. certain town - also works but switch back to “males” only view and it fails - includes “females...
  14. R

    VBA code to create vlookup formula in range

    Guys: I have to create a vlookup for a range of cells. I have included an example below. Here is my problem. How do I account for the formula when I do not know how many rows there will be in my range? I already created a variable to store my row count, not sure on the rest. Example: here is my...
  15. V

    XRL Report - Calculations switch off

    Hello all This is a bit of a strange request I update a report with an add on tool in Excel called "XRL" When the report is updated "XRL" has switched the calculations function off. I thought of trying a worksheet event change to switch the calculations back on but this is not working unless...
  16. S

    Is the new SWITCH function worth using?

    One of my colleagues has come back from training all fired up and excited by the new =SWITCH function in Excel ... but I'm struggling to see what the fuss is about. From the help guides that I have found, it just seems to be a way of hard-coding a lookup table into a single formula. While that...
  17. J

    Auto-Create Tabs VBA crashes

    Hello everyone, I'm encounter an issue with Excel when using the formula below. I have a button with the VBA code on it and it works perfectly but if my list consists of more than 15 entries, Excel crashes when trying to auto-create the tabs after the 15th entry. Is there any way to modify the...
  18. J

    VBA help

    I have a 3 work sheet workbook Sheet2 is Dropdown Sheet3 is Questions Sheet6 is Switch config Im using this to create config for a network device by answering question on the questions sheet. I am building it so going to the other sheets wont be needed. The issue I have is I need to run Switch...
  19. T

    PowerPivot Duel Clause Switch Statement..

    Is it possible?
  20. I

    Dashboard Macro Automation

    Hi All I have created a dashboard using excel. I will be displaying the dashboard on anoffice TV. I have around 5 differentworksheets on the dashboard and I want to switch between the worksheetsautomatically say every 10 minutes and loop back to the first before repeatinguntil the...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top