In the new list in an adjacent column

=IF(COUNTIF(Sheet1!A:A,A1)=0,"New","")

and copy down

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Katt595" wrote in message
...
I have two lists. The old one (for example) has 2850 rows of data, then
the
new one, has 2897 - ie 47 new fields. I need to filter out the new fields
and I have tried everything!

Can anyone help me? I have to do this job once a week and can't believe
that
my only option is to go through each list one row at a time.

Hopefully