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
Accrington
Barnet
Birmingham

<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #4F81BD"]Teams[/TD]
[TD="bgcolor: #4F81BD"]Status[/TD]
[TD="bgcolor: #4F81BD"]Teams Still Available[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #4F81BD"]"Data Validation based on Column C"[/TD]

[TD="align: center"]2[/TD]
[TD="bgcolor: #DCE6F1"]Accrington[/TD]
[TD="bgcolor: #DCE6F1, align: right"]TRUE[/TD]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="bgcolor: #DCE6F1"]Aldershot[/TD]
[TD="bgcolor: #DCE6F1, align: right"]FALSE[/TD]
[TD="bgcolor: #DCE6F1"]Aldershot[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="bgcolor: #DCE6F1"]Altrincham[/TD]
[TD="bgcolor: #DCE6F1, align: right"]FALSE[/TD]
[TD="bgcolor: #DCE6F1"]Altrincham[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="bgcolor: #DCE6F1"]Arsenal[/TD]
[TD="bgcolor: #DCE6F1, align: right"]FALSE[/TD]
[TD="bgcolor: #DCE6F1"]Arsenal[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="bgcolor: #DCE6F1"]Aston Villa[/TD]
[TD="bgcolor: #DCE6F1, align: right"]FALSE[/TD]
[TD="bgcolor: #DCE6F1"]Aston Villa[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="bgcolor: #DCE6F1"]Barnet[/TD]
[TD="bgcolor: #DCE6F1, align: right"]TRUE[/TD]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="bgcolor: #DCE6F1"]Barnsley[/TD]
[TD="bgcolor: #DCE6F1, align: right"]FALSE[/TD]
[TD="bgcolor: #DCE6F1"]Barnsley[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="bgcolor: #DCE6F1"]Barrow[/TD]
[TD="bgcolor: #DCE6F1, align: right"]FALSE[/TD]
[TD="bgcolor: #DCE6F1"]Barrow[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="bgcolor: #DCE6F1"]Birmingham[/TD]
[TD="bgcolor: #DCE6F1, align: right"]TRUE[/TD]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]B2[/TH]
[TD="align: left"]=ISNUMBER(MATCH(A2,$E$2:$E$10,0))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]C2[/TH]
[TD="align: left"]=IF(B2,"",$A2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]