I have a list with 9 fields. There are three fields --
Last, Date, and Code -- that are important. Many of these
fields repeat -- e.g. Peters, 04/05/2003, 2 -- but when
they are unique I would like to place a 1 in a fourth
field called Unique. Thus if the above data is repeated
over 10 rows -- there would be one entry which has a 1 and
the others would have a blank or 0. If the 11th record was
Hobbs, 04/05/2003, 2 then there would be a 1 in the Unique
field as at least one field has changed.

I have done this with Advanced filter. But does someone
know a way to do it through code?

Thanks for any help.

Indu