Hi Thanks,
I encountered some minor problems with the formulas:
- In my model the rent roll might consist of hundreds of tenants and many tenants will have different space so their name will appear on more than one row. This creates some issues as the formulas automatically calculates when going to the first name.
Also, when using the formulas I get N/A on some of the tenants due to their name, but don't understand exactly why.
Any advise on how to resolve this?
Bookmarks