switch

I am trying to translate the numbers from column D to text strings as follows: 0 = "A", 1 = "A#/Bb", 2 = "B", 3 = "C", 4 = "C#/Db", 5 = "D", 6 = "D#/Eb", 7 = "E", 8 = "F", 9 = "F#/Gb", 10 = "G", and 11 = "G#/Ab", into column E. This is the formula I'm using, which is not giving an error, but not...

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...

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...

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?

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...

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...

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...

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...

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...

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...

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 !

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...

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 !

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...

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...

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...

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...

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...

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...

Is it possible?