Share via

replacement for GETPIVOTDATA() when using GROUPBY() and PIVOTBY()

Anonymous
2025-03-14T16:05:47+00:00

See subject. Is there a functional replacement for GETPIVOTDATA() when using these cool newfangled dynamic array Pivot Table replacements GROUPBY() and PIVOTBY()? What/how is it done? As I was suspecting before I tried it, GETPIVOTDATA() returns #REF! when pointed at a PIVOTBY() array.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-03-15T04:04:13+00:00

    Exactly. Question was not why doesn’t it work. Question was what’s the functional replacement.

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more