• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

COUNTIF for MAX Array formula alternative method

Looking for help in finding a replacement solution for this array formula - {=IF(COUNTIF($C$3:$C3,C3)>1,"",MAX(IF($C$3:$C3=C3,$E$3:$E3)))}. The spreadsheet has thousands of rows consisting of several years and the processing time very slow.
Thank you


  • Sample Data.xlsx
    11.9 KB · Views: 1