Let’s say you have one waiter for each meal type. You need to instruct your wait staff to deliver the right meal to the right person. Now the catering company delivers the food. You know how many meals of each type to order to keep your GOT team happy, which is, as we all know, not easy at times. In plain words: In the table MealOrders (the blue table), look at the column meal choice and count how often the value of the column meal chosen from the current table (the green table) appears. The formula to calculate how many meals to order (in the green table) is a simple Countif function, which you can see in the formula bar, but here it is if you want to copy it: =COUNTIF(MealOrders]) Something like this: The blue table has the user data, the green table has the count per meal choice. (Tables are great for working with data!!) Turn that into a table by pressing Ctrl-T or click Insert > Table. Place the seven meal choices into seven cells and use a Countif function. You could build a pivot table, but since there is a fixed number of just seven meal choices, we can also just build a simple table with a formula. Now you need to work out how many meals of each type you need to order from your catering company. Once all people have returned their RSVPs, you can use Excel to organise the replies into a list with two columns: Name and Meal choice. You could use Outlook voting buttons, an Excel Online survey or something like that.) (This post is not about how to set up and collect this data. Your event would include food, so in order to ensure everybody is served food they enjoy, your RSVP form would include a question where your guests can select what type of meal they want. Imagine you’re organizing a party for the major Game of Thrones characters (or maybe just your office crowd).
0 kommentar(er)
