Hello everyone,
We use a Pivot to check sequencing errors, e.g. not starting with a 1 or if entry has max sequence of 5, but only 4 entries.
To check that we have a Pivot and 2 formulas next to it. When we refresh the Pivot the formulas are not dragged along so they have to be copied down everytime.
Is there any way to tell a Pivot that formula x should always be in column y?
Bookmarks