Path: news.mathworks.com!newsfeed-00.mathworks.com!news.tele.dk!feed118.news.tele.dk!feed116.news.tele.dk!bofh.vszbr.cz!news.radio.cz!newsreader4.netcologne.de!news.netcologne.de!newsfeed.straub-nv.de!news.mixmin.net!aioe.org!.POSTED!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: Combine columns and find the sum for the matched columns from
 a different table
Date: Tue, 17 Apr 2012 14:36:37 -0500
Organization: Aioe.org NNTP Server
Lines: 37
Message-ID: <jmkgo2$mb1$1@speranza.aioe.org>
References: <jmkbeg$pdt$1@newscl01ah.mathworks.com>
NNTP-Posting-Host: EhMj8T0S2/DZdiQOVGC1jg.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.27) Gecko/20120216 Thunderbird/3.1.19
X-Notice: Filtered by postfilter v. 0.8.2
Xref: news.mathworks.com comp.soft-sys.matlab:764896

On 4/17/2012 1:06 PM, sagar poudel wrote:
> Hi
> I am getting a problem while combining two columns (x, y) in a matrix
> (from first excel file). After the first step, I need to match the
> combined name (x,y) with similar name from a second matrix (from a
> second excel file). Then I need to find the sum of rows matching the
> name from the first matrix.
> Here is an example.
>
> Table 1 Table 2
> 1.2 1.4 1.2 1.3 20
> 1.2 1.6 1.2 1.4 30
> 1.2 1.8 1.2 1.6 20
> 1.3 1.4 1.3 1.4 35
> 1.3 1.6 1.3 1.8 40
> 1.3 1.9 1.3 1.9 20
>         1.3 2.1 35
>
> Here, the tables above have all numerical values. I have to match the
> columns 1 and 2 (x,y)(combined) from table 1 (all) with columns 1 and 2
> (combined) (x,y) of Table 2. Then, based on perfect match, I have to
> find the sum of third column from table 2....

As Bruno notes, the relationship to Matlab seems tenuous at best.
I _presume_ you're thinking of doing whatever it is that you want to do 
w/ the data from Excel by either interacting w/ Excel from Matlab or 
bring the data into Matlab from Excel and put the results back is the 
connection.

Undoubtely somebody here can process the arrays as you wish if you can 
explain precisely what it is that you mean in the above description. 
Give an example of what you mean by "perfect match" and what the results 
should be for the sample data.

Where a "name" comes from in the description I've no clue...

--