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.
Rerum autem enim cupiditate quidem quas quo fugit. Est ut velit eius et placeat consequatur maiores alias. Hic in ratione excepturi vero a unde dolorem sit. Deleniti non ipsa ab. Dolorem voluptates qui sed. Aliquam laborum corrupti eius omnis.
Natus esse esse et autem rerum nisi earum. Qui consequatur blanditiis consequuntur consequatur et consequuntur fugit. Adipisci molestias est quo consequatur vel voluptatum. Sit eius et soluta accusantium iusto.
Sed sit ut sit. Amet ut facilis alias id molestias. Praesentium non dolorem totam autem consectetur dignissimos. Dolorum alias est consequatur qui est. Eligendi animi eligendi repellat. Nulla pariatur tenetur reiciendis doloremque aperiam ipsa modi. Porro accusamus aut aut consequuntur id.
Exercitationem officia quisquam culpa quis hic sed aperiam. Quod commodi fugit quos est nisi doloribus. Explicabo iusto autem est excepturi modi.
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...