Forum Discussion

Icke197's avatar
Icke197
Copper Contributor
Nov 23, 2022

find text direct in formulas

Hi community,

 

the last few weeks I've again and again ressources errors from Excel. To find the ressouces killer I'd like to build a short list of all used formulas that shows the number of e.g. "=lookup" or "=aggregat" or others.

 

How can I search for a text string directly inside the formula and sum it up and not search in the cells value?

 

Thanks a lot in before,

Thomas

  • Icke197 

    =COUNT(SEARCH("*"&D16&"*",C5:C13))

    You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021. This formula is in cell C16 in the example.

    =FORMULATEXT(B5)

    This is the formula in cell C5 which is filled down to cell C13.

  • Icke197 

    =COUNT(SEARCH("*"&D16&"*",C5:C13))

    You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021. This formula is in cell C16 in the example.

    =FORMULATEXT(B5)

    This is the formula in cell C5 which is filled down to cell C13.

    • Icke197's avatar
      Icke197
      Copper Contributor
      Hi there and good evening,

      You made my day 😊! It works perfectly. Thanks for your prompt help.
      So I can build up the worksheet completely tomorrow 👍👌.

      Thanks again & have a nice evening 😊.
      Thomas
      • Icke197's avatar
        Icke197
        Copper Contributor
        Is there another possibility without reserving for each formula cell another cell with the formulatext method?

        Thx