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

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

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

Dave,

I think I can help here but still unsure quite what you want. We may end up
over complicating an answer for you.

Try this: Insert a new cloumn in column A.(right-click column A and insert)
simply input "Yes" and "No" next to each client/emplyee in Sheet1, so that
each person no has a yes or no next to their name in column A. Now Click on
the cloumn header A so the whole column is selected. On the Menu bar select
DATA and select Autofilter. A filter arrow will appear in cell A1. You can
select this to filter to show all the YES or all the NO. It will now be
easier to select and copy this data if required.

Can you let me know if this is what you are asking,Does this help?

"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

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