How to prevent duplicate entries in excel Gujarati

Prevent duplicates when entering data into Excel

Namskar Mitro

Ajno Apno Topic chhe Ms Excel ma Duplicate entry ne kai rite Prevent karvi ( rokhavi)

MS Excel ma Duplicate Entry ne Prevent karvai khub j saral chhe tena mate niche mujab na step follow karo

1. Saupratham je Cell ma duplicate entry prevent karvi chhe te cells ni range Select karo.
2. Data menu ma jai data Validation option Choose kro.
3. Settings tab per Click kro
4. Allow ni niche apel drop-down list mathi Custom Choose karo 
5. Have formula ni niche apel khana ma niche mujab ni formula Enter kro:=COUNTIF($range,firstcellinrange) = 1   (vadhu mahiti mete niche ni image juvo
6. Error Alert tab per Click kro
7. Style ma stop select karo, Title  ma Duplicate Entry athwa to tame je msg rathva magta ho te type kro.
8. Error Message box, ma je msg set karva magta ho te set kro jem ke nicheni image ma “The value is a duplicate” evo msg set karelo chhe
9. Have Ok per Click kro.

Tamaru Prevent duplicates set thai gayel chhe chek kari lo

Jo mitro haju pan Prevent duplicates ma koi problem hoy to a video joi lo 

Thanks