Hello - I have a spreadsheet with about 1500 employees. I need to pick a random employee from the list daily, but ONLY if they have a qualifying "x" in a column on the spreadsheet.
Example: If there is an X in column C, I want to select a random name from column B. If column C is blank -...