Thread: Using =MAX() or =MAXA() on Pivot results doesn't work
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
circuit_breaker circuit_breaker is offline
external usenet poster
  
Posts: 13
Default Using =MAX() or =MAXA() on Pivot results doesn't work
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
Reply With QuoteReply With Quote