Hi!
When I use formulas (find row) when the references are in a pivot I can`t copy the formula down. How can I do this?
Hi!
When I use formulas (find row) when the references are in a pivot I can`t copy the formula down. How can I do this?
The way I get around this is to use the cell location rather than clicking on the cell in the pivot when putting together my formula. For example if the cell you need is b4, use b4 in your formula instead of clicking in the pivot and getting a cell reference like this: =GETPIVOTDATA("example",$B$102,"example",41).
Does that make sense??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks