Forum Discussion

Fbrsn's avatar
Fbrsn
Copper Contributor
Mar 01, 2022

rept function only visible

Hello I have a question how can I use the REPT function only for cells that are filtered or visible in Excel?
excel
Formulas and Functions

4 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 01, 2022

    Fbrsn 

    The syntax of REPT is =REPT(text, number_of_repetitions)

    Can you explain how you want this to interact with a filter?

    • Fbrsn's avatar
      Fbrsn
      Copper Contributor
      Mar 03, 2022
      Like when you use the formula "subtotal(102)" that when it is applied with the filter active it only counts the numbers that are filtered or visible in the worksheet the same thing I think of doing with the formula rept example I have the cell

      A1 - text1
      A2 - text2

      When I apply the formula rept(A1;1) the result will be text1

      But I want to apply the filter and choosing cell A2 and I want to have the result Text2 because the filter is applied with cell A2 thanks

Resources