Hi all,
I have two columns and have identified duplicate and unique data, but I would like the duplicates (the matches in my case) to sit side by side each other?
In this sheet, I have 8 columns of 2 where I want this to be done. For example, in the screenshot I would like a,b and c to sit by side by side.
UPDATE: in the attachment I have two lists of words and would like the duplicates to be next to each other.
Last edited by jackdanes; 06-19-2020 at 03:45 AM.
In "C2"Formula:
Please Login or Register to view this content.
Ensure by pressing ctrl+shift+enter
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thanks for the reply. This seems to identify duplicate and unique values but not align them next to eachother.
Thanks,
It may help someone have a better understanding of what you want if you utilize the instructions in the banner at the top of the page and upload an .xlsx file that illustrates you request.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
I've added an attachment and a bit more of description.
Thanks,
The following puts duplicates next to each other:UPDATE: in the attachment I have two lists of words and would like the duplicates to be next to each other.
1. Column C: =IFNA(MATCH(A2,B:B,0),"")
2. Column D: =IFERROR(INDEX(A$2:A$20,AGGREGATE(15,6,(ROW(A$2:A$20)-ROW(A$1))/(ISNUMBER(C$2:C$20)),ROWS(A$1:A1))),"")
3. Column E: =D2
What would you like done, if anything, with the phrases that are not duplicates.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks