identify different data in two columns
 

this should be simple I know - excuse is that I've just returned back to work
after being out sick for five months so have foggy brain.

I have exported two lists of names into excel from two different areas. All
i want to do is find out the names missing from column B which are included
in column A. These are names from a database that shows the names of people
working on certain jobs and I need to make sure that the list I keep showing
skills and rates inlcude all the people from the job list, which is horribly
out of date

Hi Fitzy,

VLOOKUP() should do the trick...

=COUNTIF(A1:B:B)

If 0 is returned then you know that the name does not appear in column B.

Cheers,
A

--
We are what we repeatedly do. Excellence, therefore, is not an act, but a
habit.


"fitzy" wrote:

this should be simple I know - excuse is that I've just returned back to work
after being out sick for five months so have foggy brain.

I have exported two lists of names into excel from two different areas. All
i want to do is find out the names missing from column B which are included
in column A. These are names from a database that shows the names of people
working on certain jobs and I need to make sure that the list I keep showing
skills and rates inlcude all the people from the job list, which is horribly
out of date

Sorry, ignore the VLLOKUP() bit, it was the solution I was steering down but
opted for COUNTIF()...
--
We are what we repeatedly do. Excellence, therefore, is not an act, but a
habit.


"aristotle" wrote:

Hi Fitzy,

VLOOKUP() should do the trick...

=COUNTIF(A1:B:B)

If 0 is returned then you know that the name does not appear in column B.

Cheers,
A

--
We are what we repeatedly do. Excellence, therefore, is not an act, but a
habit.


"fitzy" wrote:

this should be simple I know - excuse is that I've just returned back to work
after being out sick for five months so have foggy brain.

I have exported two lists of names into excel from two different areas. All
i want to do is find out the names missing from column B which are included
in column A. These are names from a database that shows the names of people
working on certain jobs and I need to make sure that the list I keep showing
skills and rates inlcude all the people from the job list, which is horribly
out of date