Overwriting Formula

  • hi


    in column b of cells, i need to prevent the user from selecting the two entries.


    so the formula =COUNTIF($C$1:$C$10,C1)<=1 is applied in data, then validation..


    the problem is the user selects the figure also using data validation by creating a scroll down list..


    i cannot have both the formula and scroll down list to appear at the same time, either one would be deleted..


    i need the user to choose data from a list and at the same time prevent a double entry of data..


    any help in this area? thanks


    sam

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!