Validate data

[Josue]

Hi everybody,

I need to validate some data that an user has to insert in three rows, I already have validated data; however, the user has to insert just one value in one of the three rows. I do not know how to limitate the user to insert in just one row, I have ms office 2010.

Thanks

 

[Scott Huish]

Hi, welcome to the board!

I used F1:F3 in this example.

Select cells F1:F3 and
Use a Data Validation formula like this:

=COUNTA($F$1:$F$3)=1

 

[Josue]

thank you for your answer, however, I would like to know if there is a way to forbid users to insert a number in the other two rows. I will be very grateful for any help.

kind regard

 

[T. Valko]

thank you for your answer, however, I would like to know if there is a way to forbid users to insert a number in the other two rows. I will be very grateful for any help.

kind regard

If you have applied the validation suggested by HOTPEPPER then the user can't enter (type in) anything in the other 2 cells.

 

[Josue]

thanks, I am so grateful for your help