Find then If then Replace
hi , i have 2 x files
file 1 col1 col2 col3 col4 abc 123 text1a def 456 text2a def 789 text3a ghj 456 text4a file2 col1 col2 col3 col4 abc 123 text1 def 456 text2 def 789 text3 ghj 456 text4 after i combine them i am trying to 1. if data in col1 and col2 are the same then take data in col3 (was from file2) and replace it into col3 of file 1. 2.then delete that row (ie the row originally from file2) end result like this file 1 col1 col2 col3 col4 abc 123 text1 text1a def 456 text2 text2a def 789 text3 text3a ghj 456 text4 text4a hope that makes sense . -- cciissqq11 |
All times are GMT +1. The time now is 01:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com