Data Validation

  • Thread starter Thread starter Gotroots
  • Start date Start date
G

Gotroots

Hi,

I need to prevent data from being entered into a cell if there is already
data in any cell left or right of it in the same row.

Thanks
Gotroots
 
Using data validation you can; but only manual entries/dropdown entries will
be validated

--Select A1:J10
--Select menu Data>Validation
--Select Custom from the 'Allow' dropdown and enter the below formula

=COUNTIF($A1:$J1,A1)=1

--From the Error alert tab enter the message you want to be displayed
--Click OK and try.
 
Back
Top