Hi Experts,
Please help me on attached issue. My problem is when ever I found customer Id more then one time then the value which is mention in Lender, should copy the vertical values (transpose thin lender 2 to FWD. (Depends on the numbers of customer id) . Example I have 3 customer id then the value should go in Lender 2, 3 & 4.
I try to code it but not able to found any code. Hence there is no formula and no Code in this file.
Experts please help me on this.
Thanks and Regads
Upguy
hi Upguy. at the end, do you want to remove those duplicate customers? if you do, try:
Please Login or Register to view this content.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi benishiryo,
Thanks for giving me your valuable time, But sorry to say, Its not working. Please suggest me with some other concept.
Thanks and Regards
Upgury
Is this what you want - or do you want the rows compacted also?
If you want the rows compacted:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by xladept; 09-13-2017 at 05:14 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks