dubceeCopper ContributorAug 22, 2022Formula 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,
dubceeCopper ContributorAug 22, 2022Hi 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?
