Forum Discussion

dubcee's avatar
dubcee
Copper Contributor
Aug 22, 2022

Formula auto-update

Hello,   Is there a way to get a formula to auto-update to show only rows that are not hidden when the data set is filtered?   Thank you,
Formulas and Functions
dubcee's avatar
dubcee
Copper Contributor
Aug 22, 2022
Hi Hans,

I tried to use the aggregate function to return averages and ignore hidden rows but didn't work. Here's what I entered: =AGGREGATE(1,5,A6:K48)

Am I doing something wrong?
  • dubcee's avatar
    dubcee
    Copper Contributor
    Aug 22, 2022
    I realized what I did wrong. Thank you for your help!

Resources