| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i restrict data entry from certain columns | Excel Discussion (Misc queries) | |||
| Convert data from rows to columns | Excel Discussion (Misc queries) | |||
| Using Excel's XML mapping/export with data organized in columns | Excel Worksheet Functions | |||
| Identify end of data in worksheet, prevent overshoot | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Linear Mode
