Using =MAX() or =MAXA() on Pivot results doesn't work

  • Thread starter Thread starter circuit_breaker
  • Start date Start date
C

circuit_breaker

Hi,

I created a VBS file that creates a Pivot Table that looks like:

Count of ReleaseVer
ReleaseVer Total
---------------------
N/A 50
5555.5050 28630
3167.1111 2
5300.4444 6000
------------------------
Grand Total 34682

I'm trying to extract the highest "ReleaseVer" (5555.5050) in this
case. But neither max() or maxa() seems to work.

Thanks for your help
 
=MAX(IF(ISNUMBER(A2:A5),A2:A5))

ctrl+shift+enter, not just enter
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MAX & MAXA returning 0 value 6
Custom pivot formula 2
Pivot Table 1
Pivot table 5
Pivot table limitations 1
Pivot Table Calculations 2
Transform/PIVOT Query 4
Help on Pivot Table 2

Back
Top