Like the title says...
I have a list of names that repeat a few times in column A...
James
James
Tim
Tim
Tim
Sally
Sally
Erin
That I want column B to simply list the names without repetition...
James
Tim
Sally
Erin
I am sure there is a function that does this but with some Google searching I wasn't able to find it. Please help?
Thank you!
Hello,
Assuming data is in A2:A9,
In B2 use,
=INDEX(A$2:A$9,MATCH(1,INDEX(ISNA(MATCH(A$2:A$9,B$1:B1,0))+0,0),0))
Then copy down until gets #N/A error.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Another option, same assumption...
=IFERROR(INDEX($A$2:$A$12,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$12),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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks