Hopefully self explanatory title. I require a function that will look at a list of data in A2:A50 and remove all duplicates in the list. This unique list is to go in B2:B50.
Data in row A changes all the time. Is this fairly simple to do?
Thanks in advance for any advice.
One way ...
In B2: =IF(A2="","",IF(COUNTIF($A$2:A2,A2)>1,"",ROW()))
In C2: =IF(ROWS($1:1)>COUNT(B:B),"",INDEX(A:A,SMALL(B:B,ROWS($1:1))))
Copy B2:C2 down to row 50. Hide col B. Col C auto-returns the list of uniques from col A, all neatly packed at the top
------------------------------------
Success? Celebrate it, click the little star at the bottom left of my responses
Or perhaps this, in B2, copied down...
=IFERROR(INDEX($A$2:$A$50,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$50),0,0),0)),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you to you both, most helpful, hope to return the favour some day.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks