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