Dear All,
I am facing a little unique problem.
I have more than 7000 rows consisting of various sales item codes.
However some of the codes are changed.
I have got the list of old and new codes.
What I want excel to do is change the codes for those items, where the new codes are there and if the new code is not there then keep the old codes.
Thanks
Try this in F4 (in your Example):
Formula:
Please Login or Register to view this content.
Drag down
Hope this helps
Edit-
Added workbook to show results, and differences from Output column
Last edited by dredwolf; 04-03-2013 at 10:58 AM.
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
It worked like magic
Thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks