Hi, I have a formula which ranks values using a sumproduct. For example
=SUMPRODUCT(($A$2:$A$5815=A2)*(FY2>$FY$2:$FY$5815))+1
Problem is that it is very computational and its crashing my excel. Any chance somebody could assist with a VBA function or macro?
I have attached an Excel file with the output. Column D is what I'm looking to "fix"
Thanks a million!
Bookmarks