Thanks for your comments guys.
I guess I was trying to be too clever and completely ignored the pivot table.
I'll keep it simple next time!
Cheers
Adam
Hi,
Apologies if this has been asked before, I wasn't able to track anything down with a search.
Is it possible to use the DSUM formula with one standard set of headings and multiple criteria below them and return data based on each individual row.
For example:
Product Country
Teddy...
Hi,
I am trying to write a procedure that if a variable (portfolio), isn't found in a range (term_portfolio), then find an alternative variable (area) in an alternative range (term_area).
The problem is that using the following does not follow the Then logic when an error was expected, i.e. no...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.