I'm trying to create a list of expired items. I wonder if anyone could assist?
I'd like the list to show the column name and row name if something has expired.
Example: 3 dairy farmers (Jones, Smith, Barnes) and different products they produce (milk, cheese, cottage cheese, sour cream). Somehow, I'd like a list that compares Today() + varying timeframes (milk expiration + 7 days, cottage cheese lasting longer might be expired+14 days) and report back which person and product was expired.
Could that be done?