To pick a random name from an Excel table using a method that works across every version of Excel, this classic combination ...
SharePains by Pieter Veenstra on MSN

CountRows, CountIf, CountA and Count in Power Apps

How often would you like to count the number of records without really wanting to load all the records that exist in a list ...