Thread: Array formula for lookup a max value cost too much time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jmsla...@gmail.com is offline
external usenet poster
  
Posts: 9
Default Array formula for lookup a max value cost too much time
Amazing :)

=IF(MAXIFS(Y:Y;I:I;I2)=0;"";MAXIFS(Y:Y;I:I;I2))

9sec calculate time for 50.000 records.

THANKS !!
Reply With QuoteReply With Quote