Here's the thing: Excel *can* pick a random winner, but it won't prove you did it fairly. That's the real problem Torian17 has stumbled into, and it's a good one. Your trail organization raised money for a cause people believe in. The last thing you want is anyone questioning whether the prize draw was rigged. A simple `=RAND()` function generates a random number, but it recalculates every time you sort or edit the sheet. By the time you screenshot it, the number has already changed. That's not transparency, that's a liability.
What you actually need is a process that locks in the randomness and leaves an audit trail. Excel's `RANDARRAY` function can create a static list of random numbers if you copy and paste them as values immediately. But here's the rub: even then, you're trusting that nobody tampered with the sheet before you took the screenshot. For a small community fundraiser, that might be fine. For anything larger, you want a method that anyone can verify independently.
The better approach is to use a lightweight, verifiable tool. Services like random.org draw from atmospheric noise, true randomness, not a computer algorithm. You can record the screen while you paste your list and click the draw button. That video, combined with the timestamped result, gives you a chain of custody that a spreadsheet alone never will. Or, if you want to stay inside Excel, use a hash-based method: assign each entrant a unique ID, then use a public, verifiable seed, like the closing price of a stock or the next day's lottery numbers, to generate the winner. It sounds technical, but it's a few formulas you can set up in ten minutes.
The point here isn't about software. It's about trust. Your community donated because they believe in the trails. Don't let a sloppy random draw erode that goodwill. Pick a process that is transparent by design, not just by intention. Record it, share it, and let the math speak for itself. That's how you turn a fundraiser into a relationship-builder.