In A1:A10 of Sheet1, I have 1,2,3,4,5,7,8,9,10
In A1:A5 of Sheet2, I have 1,2,6,7,8
In B1 of Sheet I used =IF(COUNTIF(Sheet2!$A$1:$A$4,Sheet1!A1),"Here","Go ne")
I copied this down the column; now I know who is here and who is gone
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dave T" wrote in message
...
On sheet one I have a list of around 600 personell numbers (say 1234 etc)
whoa has worked or stills works within the Company. On sheet two I have
and exported list which is the updated list without the employees that has
left.

I am trying to save myself a lot of work and identify those that no longer
are with the Company (not to delete though). i.e If they are still with
the Company "Yes" if not "No".
Hope this helps
Many thanks in advance.

"OssieMac" wrote in message
...
Hi Dave,

Need more information like a sample of the existing data plus a sample of
what you want left. Maybe an explanation of the criteria for what needs
to be
deleted.
--
Regards,

OssieMac


"Dave T" wrote:

I am trying to compare 2 columns of numbers so that I can identify and
delete numbers no longer required. Can anyone help me find a formula
for
this please?

Many thanks
DT