Select a solution

  • Formula in function bar - excel 2002

    Suddenly the formulas from my cells no longer show up in the function bar when the cell is highlighted. All I get is the answer or result of the formula application. How do I get the formula back? In

  • Filter Data in DAX Formulas - Excel

    You can create filters within formulas, to restrict the values from the source data that are used in calculations. You do this by specifying a table as an input to the formula, and

  • Evaluate function with array formulas

    I like using the Evaluate function in VBA to return the results of a formula. It's especially nice because Evaluate will also return the results of array formulas. HOWEVER, today I am trying to use

  • Insert Function shows result, but formula doesn't work

    When I use 'Insert Function' to review a formula, it shows a result under 'Formula Result'. However, when I hit Enter, it results in

  • Function for counting data only not formula

    Hello, I cannot find a function that will count only the data being displayed in a cell. I tried CountA but because there is a formula on the blank cells it counts them as well. I have a list of names