Hi,
Column A is mostly unique characters, but sometimes the characters can repeat up to 7 times in that column. I need a script that will keep just one unique character and its data in that row and delete any rows where it appears again.
I have tried a few different scripts in the forum that were close to what I wanted but sadly they did not work.
Thanks for any help.
David
Try this. Change $A$1:$E$ to your range
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
The above works perfectly for 2007, is there a 2003 version?
Yea short and sweet, but only works in 2007 or greater. Try this for 2003
Please Login or Register to view this content.
Perfect, Thanks again Mike!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks