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... --