PDA

View Full Version : consolidate two worksheets. different table structure



night_p
11-19-2011, 05:03 AM
hi




I have another file with 16200 row and 4 columns.

I should combine this 2 separate sheet to a one sheet.

how can I find and set the same value and del the others ?

Is it possible or not ?

The one way is to select one by one my aim value by press ctrl key and del the others. this way take a long.



we have an excell file contain sheet1 and sheet 2 and we need to create sheet 3 by combain these to sheets.


in sheet2 we have to many excess result( 16200 ) but we need only some of them (1914 ) that similar to the parameter Node ID in sheet 1.

( the problem is this 1914 value have a iregular position in sheet2 and not sorting by a rule )

we should select these simalar Node ID From sheet 2 and in final stage combain it with the sheet 1 and make a final result in sheet 3.

In the below picture i do it manully for 4 Node ID ( just thinking that you should do a same procedure for 1914 rows :()

I hope somebody help me to do this.:help

you can download my excell file in attachment .

Thanks:love




http://picme.ir/images/27893603224706324563.jpg

nilem
11-19-2011, 06:42 AM
Try. Click the green arrow in the attached file.

night_p
11-19-2011, 11:26 AM
Try. Click the green arrow in the attached file.
hi

very good:ole:


thank you Mr.nilem.:beat

************************************************
This is my goal that I try to find a solution to draw it in a past few days:

thank you again Mr.nilem & Mr.mancubus.

http://picme.ir/images/84220149873743643669.jpg

mancubus
11-20-2011, 07:21 AM
i did nothing regarding this thread but you're wellcome.

can yo post the workbook with chart.

@nilem: good solution indeed...

night_p
11-20-2011, 09:23 AM
i did nothing regarding this thread but you're wellcome.

can yo post the workbook with chart.

@nilem: good solution indeed...

here I attache the excel file regard to the curve.

I create the chart with an especial (http://www.google.com/search?hl=en&client=firefox-a&hs=mWV&rls=org.mozilla:en-US:official&sa=X&ei=LCTJTuSSL9S7hAfn6fnVDw&ved=0CCMQvwUoAQ&q=especial&spell=1) program for civil Eng and the curve is a
(http://en.wikipedia.org/wiki/Topographic_map)
kind of topographic surface.


The name of program is : Surfer ver10.1.561

you can dl it from this link :

http://dl.downloadha.com/Adel/1389/09/Files/Golden%20Software%20Surfer%2010.1.561%20%5Bwww.Downloadha.Com%5D.zip

pass: www.Downloadha.Com (http://www.Downloadha.Com)

(If you are interested in drawing your own, tell me to guide about it )

mancubus
11-20-2011, 12:22 PM
thanks for the reply.

that site is not in latin alphabet.

i found thru google. but the rar file i downloaded consists rar files that consist rar files which consist rar files....... on and on... :bug: :bug: :bug:

so i gave up :rotlaugh: :rotlaugh:

night_p
11-20-2011, 02:26 PM
thanks for the reply.

that site is not in latin alphabet.

i found thru google. but the rar file i downloaded consists rar files that consist rar files which consist rar files....... on and on... :bug: :bug: :bug:

so i gave up :rotlaugh: :rotlaugh:

ok.

another link ( the mirror link for above address) : size :42.66 Mb

https://rs282tl3.rapidshare.com/#!download|282l3|453475668|Golden_Software_Surfer_10.1.561__www.Downloadha. Com_.zip|44742|R~97486C276F62B6D2726BDD14F0ADBA91|0|0 (https://rs282tl3.rapidshare.com/#%21download%7C282l3%7C453475668%7CGolden_Software_Surfer_10.1.561__www.Dow nloadha.Com_.zip%7C44742%7CR%7E97486C276F62B6D2726BDD14F0ADBA91%7C0%7C0)

remember, the pass for extracting file is :

www.Downloadha.Com (http://www.downloadha.com/)


after finishing download, Follow the path in the picture :

http://up98.org/upload/server1/01/y/5lbuvvjox8lxhxe64u6m.jpg

(The folder only contains 6 files, you shoul clik in the first folder to show you setup file)


I hope, the problem run away.

mancubus
11-20-2011, 04:39 PM
that link is broken...

never mind.
demo is available at http://www.goldensoftware.com/products/surfer/surfer.shtml

it's not related with my business... just wondered how...


ps: i hope that file is not cracked. it is against forum rules to violate copyrights...