consolidate two worksheets. different table structure

[night_p]

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.

you can download my excell file in attachment .

Thanks

[nilem]

Try. Click the green arrow in the attached file.

[night_p]

Try. Click the green arrow in the attached file.

hi

very good


thank you Mr.nilem.

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

[mancubus]

i did nothing regarding this thread but you're wellcome.

can yo post the workbook with chart.

@nilem: good solution indeed...

[night_p]

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 program for civil Eng and the curve is a

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/0...dha.Com%5D.zip

pass: www.Downloadha.Com

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

[mancubus]

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

so i gave up

[night_p]

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

so i gave up

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

remember, the pass for extracting file is :

www.Downloadha.Com


after finishing download, Follow the path in the picture :



(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]

that link is broken...

never mind.
demo is available at http://www.goldensoftware.com/produc...r/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...