The concatenated column is 16 characters long, it appears to only be using 14
characters... is this possible?

"Simon Shaw" wrote:

Hi,

i have a column that joins a series of other columns to creat a unque key
for a table data I have in a sheet. when I then use sumif or countif against
the concatenated column it says there is more than one the same and the sumif
produces the same total for a number of lines. visually looking at the unique
key column, I can clearly see they are different.

ideas?

Simon Shaw