Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What can I do to stop the duplicated value in a specific column or row, and if I entered a duplicated value it opens an alert window message?

user-image
Question ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/06/08
Ahmed Maher
par Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)

from the data tab select data validation customize your settings according to your rules and the message you want to add as an alert or a forcing and stopping window etc...

هاشم المشارقة
par هاشم المشارقة , Key Account Manager , Advanced United Systems Ltd. ( A member of Taj Holding Group)

I think you should go to Data tap then select Data Validation.

Mohammad Basheer abu ahmad
par Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

1- Select Data - column and row -

2- Choose the data list

3- Click on Data Validation Option

4- Select option - Data validation -

Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

the best fit solution for this situation is Data Validation.

follow this steps:

  1. select all the cells you want the validation to apply to.
  2. go to Data tab > Data tools group > Data validation command
  3. in the Data validation dialog box choose Custom from Allow combo box.
  4. in the Formula box write the formula suppose your data is the range E1:E5 : =COUNTIF($E$1:$E$5,$E$1:$E$5)=0
  5. in the Data Validation dialog box go to Error Alert tab. And write you alert message
  6. done

hope this answer your question 

More Questions Like This