The new DATA TYPES in Excel for Insiders (Beta at this point) are certainly good fun. But typing in the column title for the data you've extracted from each cell is a right pain.
If you wish to select a long list of items from the field selector, you would think that you would be doomed to have...
I created a UDF that calculates how many minutes it takes to complete a certain task.
(ex: =MinutesToComplete(1,0.18,10,50,20) )
Is there a way to extract each argument/parameter?
(ex: =RightParameter() ) and the answer would be 20
I had an Excel file, perforce, where I wanted to identify the cells containing formulas. I recalled the ISFORMULA function. I used the ISFORMULA function in tandem with an IF function and FORMULATEXT to reproduce the formulas in the respective cells.
The complication occurs in that the...
Is there any way to call a variable from VBA as the input for FormulaText in SolverAdd?
Sub ()
intX=5
SolverAdd CellRef:=Range("A1"),Relation:=1, FormulaText:=intX
End Sub
In Sheet1 I have a button that creates in Sheet2 a calculation in cell C10 that I want to be =AverageIF($C$8:$C$9; "<>0"). Pretty easy, isn’t it ?
Well naaaahhh … after many hours googling and testing different approaches, I’m still unable to make it work. Here are my attempts and the error...
I recently put together a UDF function similar to the native FORMULATEXT() function in excel. Instead of displaying the formula with the referenced cell addresses, the UDF displays the formula with the referenced cell values.
So far, it seems to be functioning like I want it to, for now (only...
Couldn't find a built in formula to do this, and didn't want to write VBA. So found a way to get the name of a table in Excel. It's a little clunky and I'm hoping for a cleaner solution,but here it is. Used three functions: MID, FORMULATEXT, and INDEX.
Have a table with name tblHarry
1...
For example:
When I click in G5, the formula is: "='Benchmark Inputs '!F18/'Benchmark Inputs '!F10"
Instead, I would like to see: $2,398,528,746 / $4,219,000,000
The values can be displayed in H5.
My formulas have a variety of general, currency, and percentage formatting.
I'm ultimately...
I am trying to verify that my separate spreadsheets are all using a consistent formula. However, there are thosands of formulas, an just copying them to each sheet is not giving me the necessary results.
I am trying to use the FORUMLATEXT function.
Specifically, =formulatext(H18)
However, it...
I've often wanted to look up if it was possible to concatenate the results of a column of concatenate formulas (of course, CONCAT only starting in Excel 2016)
I thought maybe there would be a function like "FUNCTIONTEXT" but "FUNCTIONVALUE"
So I started looking and I can't seem to find...
The formula I have in cell A1 is ='New Product Business'!A11.
I would like other cells in the current worksheet to be relative to this formula.
I came across FORMULATEXT and it seems that by combining this with OFFSET I could achieve what I need to do.
However, I have Excel 2010 and FORMULATEXT...
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.