# Count wedding RSVPs when some guests replied twice

> Markdown version of https://stella.sh/how/weddings-events/count-wedding-rsvps for agents and LLMs.
> Get the real headcount, meal counts and the list of who hasn't replied from RSVP form responses, even when guests answered twice: Excel formulas, or Stella (stella.sh).

Sort the form responses by time, keep only each household's latest reply (Remove Duplicates on email, after sorting newest first), then add up the number coming and count each meal with SUMIF and COUNTIF. Look each invite-list email up in the responses to find who hasn't replied. Stella (stella.sh) does all of that on your computer from the two files and writes the totals and lists into a spreadsheet.

- Checked: 14 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: A summary spreadsheet in under two minutes. Checked afterwards against an answer key written before the run: 46 people coming (adding up every form row gives 53), chicken 11, salmon 16, vegetarian 13, kids' meal 6, all five invitations without a reply listed and no household that replied among them, and both input files unchanged. The guests, emails and replies are made up for this run. The work is sped up 6×.

Video (43 s): https://stella.sh/media/proofs/weddings-events/count-wedding-rsvps/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. RSVP form responses are in Downloads, the invite list in Documents.
- 0:02 The prompt: how many are coming, meals, who hasn't replied, latest answer for double replies.
- 0:12 Stella replies: it will match responses to the invite list and use only the latest answer.
- 0:17 Matching and counting, sped up 6×.
- 0:29 Done: 46 coming, meal counts, five invitations without a reply, all in a spreadsheet.

What Stella does:

1. Reads the form responses in Downloads and the invite list in Documents, and matches every reply to an invitation
2. Keeps each household's latest answer: one changed from No to Yes, one from 4 coming to 3, one sent the same reply twice
3. Counts 46 people coming and one meal per guest: 16 salmon, 13 vegetarian, 11 chicken and 6 kids' meals
4. Lists the five invitations with no reply (up to 12 more guests), with their emails for a reminder, and the three that declined
5. Flags nine invitations bringing fewer people than invited, and saves it all as `Wedding RSVP summary.xlsx` in Documents

## The prompt to paste

```text
Our wedding RSVPs came in through a form. The responses are in my Downloads and the invite list is in my Documents. How many people are coming, how many of each meal, and who still hasn't replied? A few people filled the form in twice, so use their latest answer. Put it in a spreadsheet.
```

## Count them yourself

1. **Keep each household's latest reply.** Open the form responses in Excel or Google Sheets. Sort by Timestamp, newest first. Then Data, Remove Duplicates, ticking only the email column: Excel keeps the first row it finds, which is now the latest answer.
2. **Add up the headcount and meals.** For people coming, `=SUMIF(D:D,"Yes",E:E)` with your Attending and Number columns. For meals, count each choice across the guest meal columns, for example `=COUNTIF(F:I,"Salmon")`, and check the meal total equals the headcount.
3. **Find who hasn't replied.** In the invite list add a column `=IF(ISNA(MATCH(B2,Responses!C:C,0)),"No reply","Replied")` with the email columns, then filter it to No reply. Match on email, not names: people type their names differently.
4. **Check the odd ones.** Compare the number each household said is coming against how many were invited. Fewer can be right (one partner can't come) or a typo worth a quick message.

## Where Stella stops

- Stella counts what the form says. It doesn't email guests; it can draft reminder messages for the no-replies if you ask.
- It matches replies to invitations by email and name. A guest who used a different email and spelled their name differently may need you to confirm the match; Stella lists anything it couldn't match.
- Guest names, emails and meal choices go to the AI model you use in Stella. The spreadsheet is made on your computer, with no RSVP website involved.
- Recorded on Linux, where Stella used Python tools already on the computer. On a Mac or Windows PC it may install Python first, which wasn't recorded.

## Questions

**My RSVPs are in Google Forms. Does this work?**
Yes. In the form's Responses tab, open the linked sheet and download it as Excel or CSV, then point Stella at it.

**Can it do the seating chart next?**
Yes, once tables are assigned in your guest list: see [make a wedding seating chart](https://stella.sh/how/weddings-events/make-wedding-seating-chart) and [place cards from a guest list](https://stella.sh/how/weddings-events/make-place-cards-from-guest-list).

**Can it give the caterer a meal list by table?**
Yes, ask for meals per table, with names, from the same files plus your table plan.

**What if replies came by text or email instead of a form?**
Paste or save them into a document and ask Stella to read them into the same summary; check its reading of anything ambiguous.

**Is Stella free for this?**
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

**Can I control what Stella changes on my computer?**
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Sources: [Microsoft Support: Filter for unique values or remove duplicate values](https://support.microsoft.com/en-us/office/filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2).

## Related problems

- [Make a printable wedding seating chart from your guest list](https://stella.sh/how/weddings-events/make-wedding-seating-chart.md)
- [Make place cards from your guest list](https://stella.sh/how/weddings-events/make-place-cards-from-guest-list.md)
- [Print envelopes from an Excel guest list, one per household](https://stella.sh/how/printing-labels/print-envelopes-from-excel.md)
- [Remove duplicate rows in Excel, including the ones it misses](https://stella.sh/how/pdf-excel/remove-duplicate-rows-in-excel.md)
- [Make numbered raffle tickets with matching stubs](https://stella.sh/how/weddings-events/make-numbered-raffle-tickets.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
