I'm building a data set and one of the tables is based on filtered values. I'm using the
=subtotal function to sum the data, but every time I change filters all my data gets messed up. Is there a way to "lock" filtered data?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community