Selecting a random name within an IF statement

[dms11463]

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 - they are not eligible for selection.

I cannot seem to find a solution for this.

Thanks in advance for any assistance

 

[Scott Huish]

Why does it need an IF statement?

Book1
	A	B	C	D
1	Company	First Name	Eligibility
2	TEST COMPANY	Aalia		Aggi
3	TEST COMPANY	Aaron
4	TEST COMPANY	Aaron
5	TEST COMPANY	Abby	X
6	TEST COMPANY	abigail
7	TEST COMPANY	abril
8	TEST COMPANY	Addie
9	TEST COMPANY	Adela
10	TEST COMPANY	Adrian
11	TEST COMPANY	Adrian
12	TEST COMPANY	Adriana
13	TEST COMPANY	Adriana
14	TEST COMPANY	Adriana
15	TEST COMPANY	Adriana
16	TEST COMPANY	Aggi	X
17	TEST COMPANY	Aimee
18	TEST COMPANY	AJ
19	TEST COMPANY	Alan
20	TEST COMPANY	Albert
Sheet1

Cell Formulas
Range	Formula
D2	D2	=LET(a,FILTER(B2:B20,C2:C20="X"),INDEX(a,RANDBETWEEN(1,COUNTA(a))))

 

[dms11463]

THIS WORKED - THANK YOU SO MUCH