Updating a source range (e.g. bingo numbers not being "redrawn")

[DaveTopete]

Hello all,

Seeing if there is a way of a source range being "updated" such that once a value is selected from that source, it can not be selected again? An example being something like a bingo game where once B14 has been pulled, it is out of the pool of remaining selections?

Thanks in advance!

David

 

[shobolos]

Excel 2012

	A	B	C	D	E
1	Teams	Status	Teams Still Available		"Data Validation based on Column C"
2	Accrington	TRUE			Accrington
3	Aldershot	FALSE	Aldershot		Barnet
4	Altrincham	FALSE	Altrincham		Birmingham
5	Arsenal	FALSE	Arsenal
6	Aston Villa	FALSE	Aston Villa
7	Barnet	TRUE
8	Barnsley	FALSE	Barnsley
9	Barrow	FALSE	Barrow
10	Birmingham	TRUE

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B2 =ISNUMBER(MATCH(A2,$E$2:$E$10,0)) C2 =IF(B2,"",$A2) <tbody> </tbody>

<tbody>
</tbody>