Hello
I'm struggling to get a formula in which I can drag down for the whole column.
In the provided attachment in "Pivot Table 2", I have a sample Pivot table and I'm trying to write a comparison formula in which it compares the value of one column versus another. However, when I write the formula for the first one and try to do a click-and-drag to copy to all of the cells in the comparative column, Excel is not updating with the rows in the formula.
Is this even possible in Excel or am I doing something wrong?
Thanks
Bookmarks