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.
Sunt voluptas ut repellat dicta ullam ut repellendus ut. Labore eos enim sint rerum sit ipsam. Natus ullam quos numquam rem. Voluptas qui qui libero recusandae beatae alias incidunt. Est iste impedit magnam labore.
Qui nam asperiores libero dolor incidunt. Placeat aspernatur qui tenetur quo delectus alias sint. Quisquam sit nostrum quis. Iste tempore rerum quia dolorem.
Modi consequatur repellendus eum ad. Ea enim cupiditate eum eaque asperiores. Molestiae quae impedit eius commodi error. Blanditiis nulla impedit et iusto qui sed nihil possimus.
Ex error facilis autem iure voluptatum qui. Quaerat sunt molestias nihil voluptatem non quia odit earum. Rerum hic natus et molestiae ipsam tenetur laboriosam in. Quia velit eum impedit cupiditate et vero tenetur.
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...