Speed up max if array

Hi,

SUMPRODUCT() won't help here.

Create a pivot table to summarise Max of Values for each ID. That summary may be good enough for you (depending on what you want to do). If you want to put that MAX information back into column C then let us know - it's quite straightforward.