I usually start with one report then add the second report to the first by
matching the ID's. If the ID's match add the second report to a new
column(s). If the second report ID does not match then add a new row to the
report and the data to the new column(s). The rows where there isn't datta
for both reports is the reults you are look for.

I need to know the number of columns ineach report and the column which
contains the ID's.

"Pinkiredd" wrote:

I'm trying to reconcile billing that are in excel format. Both billings have
employee ID numbers. Is there a way I can merge the two files together and
get the desire results of who is not one what report?
--
Ms. Davis