Compare two files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two spreadsheets that I need to compare and then combine. The first file includes all employees including file number, name and address. The second file is for active employees only. It includes only file number and name. I want to add the second file to the first so I can eliminate terminated employees. Is there a way to do this
 
See Chip's site www.cpearson.com He has lots of stuff on comapring sheets.
Best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

Peter said:
I have two spreadsheets that I need to compare and then combine. The
Click to expand...
first file includes all employees including file number, name and address.
The second file is for active employees only. It includes only file number
and name. I want to add the second file to the first so I can eliminate
terminated employees. Is there a way to do this.
 
Check out digdb.com for great compare utility. It can
match on different choices and then combine, and show
which do/don't match.
-----Original Message-----
I have two spreadsheets that I need to compare and then
Click to expand...
combine. The first file includes all employees including
file number, name and address. The second file is for
active employees only. It includes only file number and
name. I want to add the second file to the first so I can
eliminate terminated employees. Is there a way to do this.
 
I'd use a helper column on the "All" worksheet.

Insert a new column A.
Assumes that the file numbers are in column B of the All sheet and column A of
the ActiveEmployee sheet.

Then use a formula like this:

=IF(ISNUMBER(MATCH(B1,'act emp'!A:A,0)),"Active","Terminated")

Then you can filter by that column and show just the retired employees--then
delete those visible rows.

(But I think I'd keep that info somewhere--it might come in handy. And you
could always sort/filter to show just the stuff you want.)
 
Back
Top