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


Participate now!

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