| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 -- . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match & Merge columns | Excel Discussion (Misc queries) | |||
| Look-up (match) and merge data | Excel Worksheet Functions | |||
| Match (merge) components from 2 spreadsheets | Excel Discussion (Misc queries) | |||
| Match and merge on new worksheet | Excel Worksheet Functions | |||
| Match/ Merge columns | Excel Discussion (Misc queries) | |||
Linear Mode
