In the attached workbook click the Run button on Sheet1 to create a list of required unique values in Sheet2- I TRIED IT BUT DUPLICATE VALUE REMAIN I NEED ONLY UNIQUE VALUES TO REMAIN
In the attached workbook click the Run button on Sheet1 to create a list of required unique values in Sheet2- I TRIED IT BUT DUPLICATE VALUE REMAIN I NEED ONLY UNIQUE VALUES TO REMAIN
These values are in columns Q:T.... There are 3 M's 3 10's 2 12's.... So from your example its not making any sense to me? What exactly are every solution that has been given doing wrong?
NIEVES, JORGE CRUZ, ALBERTO SUKHDEO, CHRISTOPHER MUNIR, MASHRATOON 4I7 4W7 2X8 2W9 M M M F 12 12 JIMENEZ NATIVIDAD LEONARDO MARIA VIEITEZ ELENA TERRERO HILDA HGS44QCX HGS44QDX EES86 8 10 ZH9 10 SES22QLR SES22QLS 10 ZM2017 ZM2017 ZM2018 SES22QLX ZMFOR ZMINT ZMJIME ZH9 ZMTWIL ZMVIEI ZMLAW ZM2019 ZMINT ZMLEON
Could you please post some addresses of cells in Sheet2 with duplicates among any row after Run button clicking?Originally Posted by grose456
I have found nothing of them...
Last edited by ZVI; 01-16-2017 at 05:57 PM.
@grose456 ---
Is it correct to say that you only want the UNIQUE values in each column to be left?
Usually in Excel I think of 'Remove Duplicates' to mean to remove the extra entries, leaving the first occurrence
Question: So if you start with ...
Col A
A
B
C
D
Z
A
B
C
you want to end with ...
Col A
D
Z
since A, B, and C are NOT unique?
then do the same for column B
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Posting Permissions
Reply With Quote
