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