The data has been merged into one large spreadsheet, from
the companies 2 databases. therefore, I am looking to find
all instances of the same customer number in the cust id
column , and for the same fiscal period and merge them
into a single row of data. I have tried the data
consolidation, but it isn't working for me. It gives me no
results.

Thanks

-----Original Message-----
If you created a list of unique customer id's, then you
could retrieve the
data from each companies data using vlookup or a
combination of index and
match (if the customer id isn't the leftmost column of
the data of
interest). You would have a vlookup formula in each of
two columns, with
one column showing data from company 1 and the second
showing data from
company 2 ( a column per company for each data item
returned). If the data
is number and you want to sum the data, you could combine
them with an if
formula

=if(isna(vlookupcompany1),0,vlookupcompany1) +
if(isna(vlookupcompany2),0,vlookupcompany2)

as an example.

Other things to look at are Data=Consolidate, and pivot
table report under
the data menu as well.

--
Regards,
Tom Ogilvy

wrote in message
...
I am trying to combine data from two companies into one
spreadsheet for the complex. I need to combine the rows
that contain similar data for that time period. For
example, since we are looking at 2 separate companies in
the division, we may have 2 separate entries for
customer
# 1009 for fiscal code 04/04. We would like to see just
one entry made for the entire complex. Is there a
formula,
or code to do this? I have been trying some things, but
none of them seem to work.


.