<div>
You can use the Custom option in Data Validation with a formula:<br />
<br />
=COUNT($D12:$K12)&lt;2<br />
<br />
Thanks<br />
Rob H
</div>


You can use the Custom option in Data Validation with a formula:

=COUNT($D12:$K12)<2

Thanks
Rob H

<div>
<div class="content wysiwyg-content">
How would I restrict input to only one value per row for the range D12:K12. The range for the second row would be D13:K13 and so on. There should only be one value in the specified range for each row. The value is any number between 0-99999
</div>
</div>


How would I restrict input to only one value per row for the range D12:K12. The range for the second row would be D13:K13 and so on. There should only be one value in the specified range for each row. The value is any number between 0-99999

Restrict input to only one value per row for a specified range

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.