I have a customer that is having a dinner. I was hoping to get some help with a rule that would count the different meal choices in the different columns (one column for each guest) and return a result something like: 1 Steak, 1 Halibut
Sample data attached.
thanks
Aaron Oct 12th RSVP Meal Choices by Name.xlsx.zip