Speed up max if array

Hi,

If it performs reasonably then you can further optimise it if your IDs are sorted in column A (as shown in the attachment).

This formula:

=GETPIVOTDATA("Max of Value",$G$5,$A$1,A2)

would become:

=IF(A2=A1,C1,GETPIVOTDATA("Max of Value",$G$5,$A$1,A2))

This effectively means that GETPIVOTDATA() is only called once per ID.