I have two XL files . want to create a new file by starting with file

i have 2 excel files. 1 called “a1 good” file has 5 columns and 986 rows.
the second call “b1 total” has 5 columns 1650 rows.

both files have names phone numbers , email addresses .

i want create third file ,,, call c .. takes b1 file , excludes a1 people .

do know how that?

do know how that?

ok. think understand.

open both files

in b1 file insert column (or use existing blank column)

in the blank column insert following formula on same row data commences. have assumed have column headers used row 2.

=vlookup(a2,'[file a1.xlsm]sheet1'!$a$2:$a$63,1,false)

where:-

a2 first value in file b1
'[a1.xlsm]sheet1'!$a$2:$a$63 workbook name (in square brackets), sheet name , range of data in b1. can select these ranges during creating formula , excel handle syntax)
1 next parameter assuming 1 column of data used table array (in 2 above))
false indicate exact matches.
copy formula down bottom of data in b1
values not found in a1 return #n/a
apply autofilter data in b1
set filter in column formulas #n/a
copy visible data , paste special -> values workbook
the column formulas can deleted , column #n/a in new workbook can deleted.

following screen snipped of file b1. (i used random numbers type of data irrelevant.)

more information on vlookup function @ following link:

Office / Excel / Other/unknown / Office 2010

Cororate