Speed up max if array

Hi,

There are a couple of ways to get it back into column C, but I was hoping that a summary table alone would be sufficient. Out of interest, is there a particular reason you need to put the max back in your 25,000 row table?

Honestly, I haven't tested the efficiency of the different approaches, but the first effort I would make would be to use the GETPIVOTDATA() function. I'll be interested to hear how it performs for you on that large data set.

Once your pivot table is set up to return the Max of Value for each unique ID (row field), the formula in column C2 would be something like:

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

Where G5 is any cell in the pivot table. I hope it performs better than the array formula.