Hello every one,
I have two worksheets: "1" and "2" Now i want to filter all symbols used in Column A sheet "1" and list them in Column A of sheet "2". The results should
contain no duplicates.
For example:
_________________________
S1, Column A
love
story
history
forum
stra~e
m§ger
w+&tte
searچ
Now i need a makro which gives following result in column A of sheet "2" (!no duplicates!):
2, Column A
l
o
v
e
s
t
r
y
h
i
f
u
m
a
~
§
g
w
+
چ
________
Thanks for each assistance in advance.
Last edited by wali; 06-10-2009 at 04:04 AM.
Give this macro a try:
Please Login or Register to view this content.
Last edited by JBeaucaire; 06-09-2009 at 08:40 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
wali,
See the attached workbook "Collect all used symbols letters from a Column - wali - SDG.xls" with macro "CollectCharacters".
Then run macro "CollectCharacters".
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Dear JBeaucaire,
thank you very much for your help. Its working very well except that it allows duplicates. thanks
Dear Stan,
thank you very much for your help. It works perfectly. Million thanks for your help
This line of code removes all the duplicates:
Can you give a demonstration of data that resulted in duplicates? I'd be interested to see where it failed.Please Login or Register to view this content.
dear JBeaucaire,
thank you very much. Its working. thans
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks