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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |