how do I validate the value and not the formula in excel?

G

Guest

I have two columns of data which seperately may have duplicates but when
combined are unique numbers.
example:
Row Col. A Col. B Col. Z
1 4 101 =A1&B1
2 4 101 =A2&B2
3 4 101 =A3&B3

I would like to use the countif function to validate the combined. Right
now the countif validation is checking against the formula and value but I
just want to check against the final value.

Any thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Critical Counitif formula 3
fixed cell in formula calculation 2
How do I modify database criteria at formula level? 3
Invert a column 5
how to use if formula in list (data validation list) 1
Formula How? 2
Is there a formula that can do this? 3
How do I find max then sum cells above & to the left? 5

Top