#1
|
|||
|
|||
Urgently Support!
There are three sheets in this workbook. The column’s names are the same on all sheets. For example, these are A-B-C-D columns.
The data in column C of a sheet will be compared to the information in column C of the other two sheets. If the same information is available, the information in column A and column B will be look the same. A-B-C names is added to a new page. If the matching information is two, two information of the match or three, three info of the match is automatically added to D columns on the new sheet. There are about 200,000 rows in each sheet. A, B Text C, D Number format. Sheet1: A B C D Info1 Info2 Info3 Info4 Info1 Info2 Info5 Info6 Info15 Info16 Info17 Info18 Sheet2: A B C D Info1 Info2 Info3 Info8 Info1 Info2 Info6 Info10 Info7 Info9 Info3 Info11 Info15 Info16 Info17 Info19 Sheet3: A B C D Info1 Info2 Info5 Info14 Info1 Info2 Info12 Info13 Info15 Info16 Info17 Info20 The new sheet will be automatically in the following. A B C D1 D2 D3 Info1 Info2 Info3 Info4 Info8 Info1 Info2 Info5 Info6 Info14 Info15 Info16 Info17 Info18 Info19 Info20 Thanks, Alime Yüksel |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Urgently!!,need help on formula | JOVIN | Excel | 0 | 10-09-2014 03:55 AM |
Need help urgently | Fozmassey | Office | 0 | 06-06-2013 01:21 AM |
Tab leaders, help needed urgently | schubi | Word | 5 | 02-23-2013 06:29 AM |
Newbie, need help urgently!!!!!!!!! | Ali | Publisher | 2 | 03-16-2012 07:22 AM |
Help needed urgently | sirdavid | Outlook | 2 | 11-30-2010 11:24 AM |