To pick a random name from an Excel table using a method that works across every version of Excel, this classic combination ...

See how try and otherwise protect custom column math from type errors in Power Query, saving time and keeping your refresh ...