I've posted an example. Ignore the errors in A through E; it's the Yellow errors I'm looking for help with.
Basically, people list a description of the Requisitions they do. Descriptions are like "Translations, Invoice xxx", "Translation Invoice xxx", "DayCare-68P","Daycare-63P", "DayCare Service", etc. I need a formula to return the first date of Daycare, no matter how the Description reads, or the first date of translation. I thought my Aggregate formula would get it but it's not working the way I want. I can't do a dropdown to choose because, for instance, Daycare has 200 different service codes that could be used with it, and the whole "Descr" field is supposed to be just a way to keep track of pending stuff, but my boss want's to gather statistics based on it.
Bookmarks