yes the calculation is updating... I hit F9 to be sure.

I also have used the advanced filter for unque values and the two lists are
the same length indicating it is a true unique key.

"Anne Troy" wrote:

Are you sure the formula is updating?
*******************
~Anne Troy

www.OfficeArticles.com


"Simon Shaw" <simonATsimonstoolsDOTcom wrote in message
...
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