I am trying to run a check to ensure that each of a list of numbers is entered in a range once and only once. For example, in range 1 I specify the values 1,2,3,4. In range 2 I enter data. Range 2 may include blank cells, and may include the range 1 values in any order, but I want to highlight an error condition if any of the numbers in range 1 are absent or repeated.
It needs to be flexible so that range 1 can be extended to include more values (i.e. I don't want to hard code the range 1 values).
I thought a countif might work with an array, but I couldn't get it to work.
Any help would be appreciated.
Thanks in advance,
Terry
It needs to be flexible so that range 1 can be extended to include more values (i.e. I don't want to hard code the range 1 values).
I thought a countif might work with an array, but I couldn't get it to work.
Any help would be appreciated.
Thanks in advance,
Terry