I need to show the Plant on a summary from a list of daily entries. The summary includes a sum of Ticket quantities and an average of Batched quantities based on a report number and design number. In addition I want to show the plant name if all the plant names are the same. If they are not the same then I want to show "Unmatched".
What I can't figure out is how to have the plant names compared and if they are the same, show the plant name. Attached is an example of my data. I've highlighted what the results should be in the summary area.
I'd like to stick to a formula, but am not adverse to using VBA if necessary.
Thanks for any help.
Bookmarks