Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare two files and merge rows base on a matching word within thesetwo rows
I have two file with several colomns. I need to compare two Col B fileA Col B of FileB as shown in example. http://spreadsheets.google.com/ccc?k...nlue nc&hl=en Each col have about 1000 rows. Each row contains thousands of words and phrases separated by Comma. As you can see from example, my data has soo many words and phrases separated by comma in each row of two colomn A and B. ============== i Need to merge data of corresponding row from COLA$FileB TO corresponding row of COLA$FileB Also merge data of corresponding row from COLB$FileB TO corresponding row of COLB$FileB with following condition. If any word or phrase from any row of COL B file B match to any row of COL B FILE A. note: There are thousands of words which in each row of Col B of both files separated by commas. ============== Please reply back if i am able to explain correctly thanks for your reply in advance thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare two files and merge rows base on a matching word withinthese two rows
Reminder
I have two file with several colomns. I need to compare two Col B fileA Col B of FileB as shown in example. http://spreadsheets.google.com/ccc?k...iNDFLamcybXdhW... Each col have about 1000 rows. Each row contains thousands of words and phrases separated by Comma. As you can see from example, my data has soo many words and phrases separated by comma in each row of two colomn A and B. ============== i Need to merge data of corresponding row from COLA$FileB TO corresponding row of COLA$FileB Also merge data of corresponding row from COLB$FileB TO corresponding row of COLB$FileB with following condition. If any word or phrase from any row of COL B file B match to any row of COL B FILE A. note: There are thousands of words which in each row of Col B of both files separated by commas. ============== Please reply back if i am able to explain correctly thanks for your reply in advance thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I mail merge data base from Excel to word | Excel Discussion (Misc queries) | |||
Merge rows from 2 XLS files using a common key field. | Excel Discussion (Misc queries) | |||
Matching rows in 2 sheets and copying matching rows from sheet 1 t | Excel Programming | |||
Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
Merge from Excel to Word - why are only even rows merged? | Excel Discussion (Misc queries) |