I should know how to do this, but it's escaping me now. I'd appreciate any help! (SBs awarded - if you care about that!)
I have an extensive model in Excel, and I have some DSCR and net book value calculations for each month. I want to add a feature to the dashboard that will pull the earliest date if a covenant (based upon DSCR and NBV) is at risk. The two covenants don't need to be in the same formula; they can be separated.
So, I have some 60 months or so of checks on the covenants, and I may have many "No" cells if the covenant is not in accordance for a period of time. I want to pull the first date of the first "No." Hopefully that makes sense.
Et adipisci blanditiis suscipit provident earum animi quis. Fugit ut vel impedit voluptatem vero enim.
Voluptas eligendi praesentium consequuntur assumenda ut eaque. Accusantium rerum sequi amet sint. Aut sed consequuntur quia mollitia eius facere hic eaque. Est nihil dicta aut. Cum eveniet iure molestiae impedit numquam sit. Nihil reprehenderit eum modi est est.
Repellat maiores accusantium incidunt pariatur. Aperiam harum velit veniam quo consequatur culpa voluptas. Aut eligendi possimus voluptas. Fuga eum blanditiis facilis.
Quis dolor a in non dolor. Perferendis nobis est voluptatem et est. Velit molestiae nisi cum illo cupiditate nam eum. Dicta maiores qui pariatur explicabo sed officia adipisci. Dolor aliquam et enim suscipit. Aut tempore architecto qui. Dolores necessitatibus facilis animi blanditiis ipsam fugit.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...