“I love the RANK function, but it really causes a problem if there are two values the same. I’d like to create a unique list so that if there are duplicate values, it ranks them in order; for example:
Hello,
I work as a jr financial modeling analyst for small company in Jordan
Hi Danielle,
The course that on Financial Modellign has been helpful in laying out my current Fin Model. I have used most of our discussion points.
But am facing a few isssues of a different kind. Th model I have created is fairly large. with a combination of Sumproduct & Lookups. Was wondering if you can help me with a few quick tips on reducing file size.
The current file size is around 12 MB with the backend datasheet for around 2000 rows, across 60 months and a few more coloumns for identifiers.