Forum Discussion

bkunse's avatar
bkunse
Copper Contributor
Feb 09, 2023

limit the inserts of certain word in one column

Hi.   Can I limit the inserts of certain word in one column? I am trying to limit inserts in certain column. For example the word "LD" can be written in each column only 5 times and not more. Simi...
BI & Data Analysis
excel
Formulas and Functions
bkunse's avatar
bkunse
Copper Contributor
Feb 09, 2023

Riny_van_Eekelen 

I have tried that but it dosen´t prevent me from writing LD the 6th time.

 

 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 09, 2023

bkunse Did you apply the data validation rule to the entire range of cells where you want to limit the entry of LD to max five times? Try the attached file.

  • bkunse's avatar
    bkunse
    Copper Contributor
    Feb 09, 2023
    I figure it out now.

    Thank you for your help.
  • bkunse's avatar
    bkunse
    Copper Contributor
    Feb 09, 2023

    Riny_van_Eekelen 

    It works in yours but when I do the same in mine it doesn´t.

Resources