Capture.JPG
Attachment 214421
hope image shows up here
Capture.JPG
Attachment 214421
hope image shows up here
On Column B9
Note : on Column A1:A6 must "No Duplicate"![]()
Please Login or Register to view this content.
Thanks for replying.
This was a small sample and there are duplicates.
See attachment.
@ Liberator, if the given solution to you doesn't work can you upload a real workbook for the members to work with.
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
By the way, if look up value only has 2 row that duplicated, and you input more than 2 row, what is the result?
Liberator, please do not post duplicate threads! I will close the other thread, you can continue on this 1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
see attached workbook
sorry for posting in wrong forum
If you don't mind with little trick, this will do:
Thanks. that's close but I think i need a loop
move b1 right (value of A1)
move b2 right (value of A2)
and so on...
numbers in colum A will be changing and the data in B moves to the right like a horse race.
Hello Liberator,
Maybe the attached WorkBook could work for you.
Also see the "Please consider" note at the bottom of this post.![]()
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello Liberator,
Glad I could help.
Thank you for the Rep.
Maybe the attached Workbook will suit you better, see formula in A9 and down.
Please remember to mark your Thread as solved, if you are satisfied with the solutions offered.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks