Hi All,
I've created a searchable drop-down list that populates a graph based on the assay selected. I'm trying to anticipate the event where no assays are done for an entire month or months. I'd like to compute "NA" for the time column if for any month(s) there is no data and still have the graph populate properly. I tried adding iterations of =if"&Metrics!G9,Table1[Date],"=””,NA() with no success. So say for the months of March and May there will be no data for those two months. I'd like to amend the formula so that an "NA" populates for the time column for those months so that the graph display correctly. Thanks again for all your help. I have attached the workbook for your review. Any help you guys could provide will be greatly appreciated.
Bookmarks