|
-
Feb 13th, 2006, 12:03 PM
#1
Thread Starter
Addicted Member
Looping Thru Cell List??
What would be the best approach to removing duplicates in a list with a definate seperator? Here is my issue: Cell "A1" has a list of numbers seperated by a "\". I know I can split the list by using SPLIT(expression,"\"). Now once the list is split I want to put only once instance of a number back in the cell i.e. Cell "A1" has the following numbers: "5\5\5\10\10\15\15\5\10" What I want to have is: "5\10\15"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|