**Our Take: Random selection shouldn't require a spreadsheet expert. This clinic is doing essential work, serving patients who need care, and the lottery process that decides who gets seen is stuck inside a tool that wasn't built for it. That's not a user problem. It's a design gap.**
The person asking for help describes a setup many smaller organizations know well: a Microsoft Form feeding responses into Excel, and a manual or half-built process to pull random selections from that list. They need 11 names, a second tab for selected patients, a clean way to purge old data every six months, and duplicate detection based on phone numbers. None of these requests are exotic. Every one of them is something a well-designed spreadsheet environment should handle without the user hunting for help on a forum.
What this reveals is a mismatch between the tool's potential and its real-world usability. Excel can randomize rows. It can filter duplicates. It can move data between sheets. But doing all of that reliably, especially when the process repeats every six months, requires formulas, VBA, or third-party add-ins that most clinic staff don't have time to learn. The result is wasted hours, risk of error, and a bottleneck where technology should be invisible.
The practical takeaway here is that the solution isn't more Excel expertise. It's a system that makes random selection a native action. An AI-native spreadsheet, for example, could interpret plain-language instructions like "select 11 unique patients from this list and move them to a new tab" and execute the entire workflow. It could detect duplicates by looking at the phone column without the user writing a conditional formula. It could archive or delete entries based on a date rule the user sets once. The clinic workers should focus on patient care, not on debugging spreadsheet logic.
This story is a reminder that productivity tools earn their keep when they remove friction, not when they demand more from the user. The person who posted this request is not asking for something unreasonable. They are asking for a tool that works the way their job actually runs. That's the standard any spreadsheet should meet, and it's one we should hold every data tool accountable to.