Thread: Using =MAX() or =MAXA() on Pivot results doesn't work
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Using =MAX() or =MAXA() on Pivot results doesn't work
=MAX(IF(ISNUMBER(A2:A5),A2:A5))

ctrl+shift+enter, not just enter


"circuit_breaker" wrote:

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