In a1 = a,b,c,d in b1=a,f,g,h,c
I not exists in b1 then in c1 = f,g,h,b,d
Else has exists in B1 then d1 = a,c
Loop until A10 and B10
But still errrorPlease Login or Register to view this content.
In a1 = a,b,c,d in b1=a,f,g,h,c
I not exists in b1 then in c1 = f,g,h,b,d
Else has exists in B1 then d1 = a,c
Loop until A10 and B10
But still errrorPlease Login or Register to view this content.
Last edited by daboho; 01-01-2018 at 08:23 AM.
What about a short Excel example, to be sure we are working on the same data ...!
- Battle without fear gives no glory - Just try
Perhaps ...next code
Please Login or Register to view this content.
Last edited by PCI; 01-01-2018 at 09:01 AM. Reason: Typo
Another option:-
Regards MickPlease Login or Register to view this content.
And another...albeit unorthodox
Please Login or Register to view this content.
Last edited by Sintek; 01-01-2018 at 10:51 AM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Another option !!
Regards MickPlease Login or Register to view this content.
Thank every body great job
MickG
I want ask you
What the meaning
2x transpose in (after first transpose then transpose again what mean thank
Please Login or Register to view this content.
Double transpose is used because Join needs a 1-dimensional matrix.
can also be written asPlease Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.Please Login or Register to view this content.
Last edited by bakerman2; 01-01-2018 at 12:47 PM. Reason: Explanation double transpose.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank bakerman
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks