Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
How-To Geek on MSN
How to pick a random name from a list in Excel
Select winners in Excel using classic INDEX formulas or modern CHOOSEROWS and TAKE combinations.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results