In my spreadsheet, i have columns W through Z showing dates of insurance. What i would like to do is hide these columns and have column V be more of a "summary" of these insurances. For example, if any of them are expired (being less than today), it would simply list the name of insurance that is expired. My issue is you could have multiple insurances that are expired, not necessarily in order. Is there any better way to do this then creating a formula that has if statements referencing every possible scenario?
Ins Example.PNG
Above is a screen shot. For for example, on the bottom highlight, you seel GL, WCB and Excess are all expired. So i would want it to say "GL,WCB, EXCESS EXPIRED". If they were all expired, it would simply say "ALL INS EXPIRED". If there is no way to do this than a ton of if statements, then just let me know.
Thank you.
Bookmarks