formulatext

  1. DRSteele

    DATA TYPES and columns headers

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

    UDF involving Split function or Formula Text?

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

    Excel Formula Situation; Relatively Direct Method to Produce Formula Counterparts for Text Strings

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

    VBA Solver FormulaText

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

    AverageIF errors when formula is created from another sheet

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

    UDF - Function Address to Values - Trig functions issues?

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

    Cell formula that returns the name of a table

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

    How to display cell values in formula instead of references?

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

    FORMULATEXT function issue

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

    Create Formula from another Formula - Nesting Concatenate Concat

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

    Is there an Excel 2010 equivalent for FORMULATEXT?

    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'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
Back
Top