This works! Now is there a formula that can select one of these entries
randomly!

"Shane Devenshire" wrote:

Hi,

1. Highlight the range where you want to put the name 300 times
2. Type the name but don't press Enter
3. Press Ctrl+Enter

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Rebecca" wrote:

Hi. I have never written an excel formula and am a complete newbie. My end
goal is to select a winner for a drawing. All employees who made loan
referrals are entered to win a prize, and are entered for each referral made.
Some have made more than 150 referrals. I don't want to type in the names
hundreds of times for 3 dozen employees. I also hope that once all the names
are created for me, excel can do a random sort, and choose a winner.