Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two files and update data from another file base on words ina cell separated by commas
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 | |||
Reversing the order of data separated by commas within a cell? | Excel Discussion (Misc queries) | |||
How do I de-concatenate items separated by commas! | Excel Discussion (Misc queries) | |||
Help! I need a formula to add numbers separated by commas within | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
MSExcel--words in a cell separated by comma need to be moved into. | Excel Worksheet Functions |