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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I validate the value and not the formula in excel? (https://www.excelbanter.com/excel-worksheet-functions/90571-how-do-i-validate-value-not-formula-excel.html)

BHemel

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

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?

Barb Reinhardt

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

Can you show us the formula you are using for the countif?

"BHemel" wrote:

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?

All times are GMT +1. The time now is 06:57 PM.