Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 Excel Lists and Appending if entries are in both
Hi. I need a little assistance. I am trying to develop a formula to
append an indicator to a row of data if there is a match. I have 2 lists of data - one is all of the employees of company and the other is a list of a department's members - both employees and contractors. I need to identify and append an indicator of those who are employees. There will be an exact match on names. The Employees list - is 1 column of Names The Department list - is a small database in excel with the following 4 fields: Name Address Month Hours Worked ( Status) What I want to do, if if the Name on the Department list is also on the Employee list, I would like to append a fifth field to the record (called Status) with the Indicator of Employee, else Contractor in the Department List. I am trying to do this as elegantly as possible. Thanks to all who are willing to help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 Excel Lists and Appending if entries are in both
There are several tests for set membership. One is using the COUNTIF()
function: =IF(COUNTIF(_list_, A2)=1, "Employee", "Contractor) In place of _list_ you would put something like G:G (for an entire column in the same list) or Sheet1!G:G (in another sheet) or 'Employee List'!G:G (for other sheets whose names contain spaces) HTH Kostis Vezerides |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 Excel Lists and Appending if entries are in both
Thanks. I believe this will fit the bill.
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing 2 Excel Lists and Appending if entries are in both
Thanks. I believe this will fit the bill.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|