Hi,
I have a very basic sheet that calculates rejection %, based on two columns. Is there anyway of making the numbers in the first few rows update when I filter on the relevant clusters as opposed to keeping the original column amounts? Thus changing the rejection percent.
Many Thanks in advance
Bookmarks