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