Custom Data Validation : drop down list

[Kanashii7]

Hello !!!

I am completely stuck here !

I would like to create a drop down list with 2 items but I have a limited amount of those items.
I have 10 "Item A" and 5 "Item B". I would like my drop down list to only allow me to input 10 "Item A" and 5 "Item B".
That is to say once I have selected 5 times "Item B" it disappears from my drop down menu...

How can I do that ?

Here's my file...
Essais.xlsx

Thank you !!!!!!

 

[tygrrboi]

I would put This in your Data column instead of just values.

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #006107}span.s2 {color: #0057d6}span.s3 {color: #ab30d6}</style>F2
=IF(COUNTIF(B3:B17,"ITEM A")>9,IF(COUNTIF(B3:B17,"ITEM B")>4,"","ITEM B"),"ITEM A")

F3
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #006107}span.s2 {color: #0057d6}span.s3 {color: #ab30d6}</style>
=IF(OR(F2="ITEM B",COUNTIF(B3:B17,"ITEM B")>4),"","ITEM B")

Then with those two cells selected as the data validation list, It should adjust itself as you put in items down the list.

 

[Kanashii7]

IT WORKS !!!!!!!

Thank you so much !