I am using =countif(a:a, a1)1 to look for duplicate values in a spread sheet
and I have copied this formula to the end of the list. However the sheet in
question is updated by a team of about 10 and is constantly growing. Is it
possible to assign this condition to the entire column so that I don't have
to coninuously keep updating it?

As well does anyone know a formula that would look for duplicates in one
column however use the value in another column as a condition as well. For
example, I have invoice numbers in colum A which I use =countif(a:a, a1)1 to
look for duplicates. However, some duplicates are allowed as I may have two
vendors who will use the same invoice number. Therefore if there is a
duplicate in column A, it will not be returned as a duplicate since the
values in column C are different.

Any ideas would be helpful.

Thanks,

Brent