DATA VALIDATION: dropdown "x" and no more that one "X" in the range

[itr674]

If I have a range, C4:G4, where I want to place an "X" to indicate a size, but there can be no more that one "X" in that range, is there a way to do that with Data Validation, or will it have to be VBA? This is a sizing chart to send to members and them to mark...

 

[KevCarter]

Please try entering the following in the data validation dialog box.

[COLOR=#000000][FONT=&quot]=COUNTIF($C$4:$G$4,"X")<=1[/FONT][/COLOR]

 

[itr674]

I had already used that in Allow Custom, but I was wanting to be able to use the Allow List and Allow Custom together...

 

[andybrown115]

Hi there

Indeed, and it's nice and simple.

Select your cell

#VALUE!

 

[andybrown115]

Hi there

Indeed, and it's nice and simple......

I've just re-read your question, and my solution wouldn't work for you - I realise now you need only one 'x' in the range

Let me have a think!

 

[KevCarter]

My apologies, I must have misunderstood your question.

 

[itr674]

Just figured out I could use a "helper" cell with =if(COUNTIF($C$4:$G$4,"X")>=1,"","X") and that way when an X was selected from the Allow List "helper" cell, it would be blank in any other cell in the range so another X could not be selected ...

Now to try andybrown115 solution...​

<strike></strike>
​