Hello everybody
I have in Data sheet two lists (List one is in column A & B - List Two is in column D & E)
There are similar data in columns A & D
In the output sheet I need to check the similar data and bring each similar data (in A & D ) besides each other
and the unique data in columns A & D to be in separated columns G & H
There is the desired output needed ..
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Maybe:
Please Login or Register to view this content.
Thanks a lot Mr. John for this great solution.
There is a problem with the original file as there are large amounts of data (30,000 rows) so it takes long time
If it is possible to use arrays to do that task ..
Thanks advanced
Hi,
Please Login or Register to view this content.
Regards
Maybe this will help?
Please Login or Register to view this content.
Thanks a lot Mr John for this modification. It makes the code better but it still slow a little
Mr. Karedog
I'm admired of your solutions as you are perfect at using array which considered faster than looping with large amounts of data
I'm sorry for bothering you again
I need the desired output to be in the output sheet and to change a little in the layout if possible (illustrated again in the attachment)
Sorry for changing my layout ...
I cannot catch your expected output with current data.
Please add more data like this :
on cell A7, add "H"
on cell D6, add "I"
What is the expected result ?
Mr. Karedog
I have two lists (each list in two columns) in Data sheet
Required to have the similar strings in column A & D (or in other words exist in the two lists) and put these similar data next to other then ...
as for not existed in the two lists to be put away in separated column
The output is the outline of my desired results
What I want to know is the order of the unique data, are they proceed by columns or by rows ?
From your current file (post #6) :
if proceed by columns (collect all uniques from column A first, then advanced to column D), the result is B, E, G
if proceed by rows (collect all uniques from row 1 first, then advanced to row 2, etc), the result is also B, E, G
Both method yield same result, so I don't know which method that you want.
But if more data is added as in post #7 :
on cell A7, add "H"
on cell D6, add "I"
if proceed by columns, the result is B, E, H, G, I
if proceed by rows, the result is B, E, G, I, H
Two methods yield different result.
Or, is the order is not important at all ?
The order is not important ..
The result should be as you mention B, E, G
Please Login or Register to view this content.
Thank you very much
It is very long but impressive
Thanks a lot for this wonderful solution
If the blank and comment lines are ripped, and I "borrow" some of famous member's coding style, the code can be compressed so much.
Please Login or Register to view this content.
Thank you very much for caring about that
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks