If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE,
''''''''''''please help me to find the result as shown as folliows
'Sheet1 Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 a2 b2 c2 a3 b3 c3 a4 b4 c4 a5 b5 c5 a6 b6 c6 a7 b7 c7 a8 b8 c8 a9 b9 c9 a10 b10 c10 a11 b11 c11 a12 b12 c12 a13 b13 c13 a14 b14 c14 a15 b15 c15 a16 b16 c16 a17 b17 c17 'Sheet2 Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 a2 b2 c2 d2 a3 b3 c3 a4 b4 c4 a5 b5 c5 a6 b6 c6 d6 a7 b7 c7 a8 b8 c8 a9 b9 c9 a10 b10 c10 a11 b11 c11 d11 a12 b12 c12 a13 b13 c13 a14 b14 c14 a15 b15 c15 a16 b16 c16 a17 b17 c17 d17 'Sheet3 Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 d1 e1 a2 b2 c2 e2 a3 b3 c3 d3 e3 a4 b4 c4 a5 b5 c5 d5 a6 b6 c6 e6 a7 b7 c7 d7 e7 a8 b8 c8 a9 b9 c9 a10 b10 c10 d10 e10 a11 b11 c11 a12 b12 c12 d12 a13 b13 c13 d13 e13 a14 b14 c14 a15 b15 c15 a16 b16 c16 d16 e16 a17 b17 c17 'RESULT_SHEET Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 d1 e1 a2 b2 c2 d2 e2 a3 b3 c3 d3 e3 a4 b4 c4 a5 b5 c5 d5 a6 b6 c6 d6 e6 a7 b7 c7 d7 e7 a8 b8 c8 a9 b9 c9 a10 b10 c10 d10 e10 a11 b11 c11 d11 a12 b12 c12 d12 a13 b13 c13 d13 e13 a14 b14 c14 a15 b15 c15 a16 b16 c16 d16 e16 a17 b17 c17 d17 -- |
#2
|
|||
|
|||
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE,
If a1-a17 are really continuous and identical in all sheets like in your
example then enter this formula in A2 in result sheet and fill it to the right and down: =IF(NOT(ISBLANK(Sheet1!A2)),Sheet1!A2,IF(NOT(ISBLA NK(Sheet2!A2)),Sheet2!A2,IF(NOT(ISBLANK(Sheet3!A2) ),Sheet3!A2,""))) -- Regards! Stefi „shyam” ezt *rta: ''''''''''''please help me to find the result as shown as folliows 'Sheet1 Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 a2 b2 c2 a3 b3 c3 a4 b4 c4 a5 b5 c5 a6 b6 c6 a7 b7 c7 a8 b8 c8 a9 b9 c9 a10 b10 c10 a11 b11 c11 a12 b12 c12 a13 b13 c13 a14 b14 c14 a15 b15 c15 a16 b16 c16 a17 b17 c17 'Sheet2 Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 a2 b2 c2 d2 a3 b3 c3 a4 b4 c4 a5 b5 c5 a6 b6 c6 d6 a7 b7 c7 a8 b8 c8 a9 b9 c9 a10 b10 c10 a11 b11 c11 d11 a12 b12 c12 a13 b13 c13 a14 b14 c14 a15 b15 c15 a16 b16 c16 a17 b17 c17 d17 'Sheet3 Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 d1 e1 a2 b2 c2 e2 a3 b3 c3 d3 e3 a4 b4 c4 a5 b5 c5 d5 a6 b6 c6 e6 a7 b7 c7 d7 e7 a8 b8 c8 a9 b9 c9 a10 b10 c10 d10 e10 a11 b11 c11 a12 b12 c12 d12 a13 b13 c13 d13 e13 a14 b14 c14 a15 b15 c15 a16 b16 c16 d16 e16 a17 b17 c17 'RESULT_SHEET Header 1 Header 2 Header 3 Header 4 Header 5 Header 6 Header 7 a1 b1 c1 d1 e1 a2 b2 c2 d2 e2 a3 b3 c3 d3 e3 a4 b4 c4 a5 b5 c5 d5 a6 b6 c6 d6 e6 a7 b7 c7 d7 e7 a8 b8 c8 a9 b9 c9 a10 b10 c10 d10 e10 a11 b11 c11 d11 a12 b12 c12 d12 a13 b13 c13 d13 e13 a14 b14 c14 a15 b15 c15 a16 b16 c16 d16 e16 a17 b17 c17 d17 -- . |
Thread Tools | |
Display Modes | |
|
|