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

[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

 

[Teethless mama]

=MAX(IF(ISNUMBER(A2:A5),A2:A5))

ctrl+shift+enter, not just enter