Hello everyone
I have numbers in range("A2:A" & Last Row)
I need to get the unique digits within each cell
For example:
A2 : 5967887965658
the desired results would be to adjacent columns
Thanks advanced for help
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
maybe so
Please Login or Register to view this content.
Thank you very much for this swift and great solution
It works as expected exactly
Best Regards
I need to create UDF function to count unique digits within the number
Sorry for disturbing you again
one way
Please Login or Register to view this content.
UDF returning array :
Usage :Please Login or Register to view this content.
Select C2:J2 for example, then enter this array formula (confirmed with Ctrl Shift Enter keys) :
Formula:
Please Login or Register to view this content.
If the selected range to hold the array is too little (for example C2:E2), the last cell will be filled with this text : "more ...", indicating that you must enlarge the range.
The range itself doesn't need to be row based, but you can select column based (C2:C10 for example), or rectangular area (B2:C3 for example)
Thank you very much Mr. Nilem for this great UDF function ...
As for my example is perfect as I have only digits not characters ..But what if I need to count the digits only (unique digits not all the digits)?
Thank you very much Mr. Karedog for this new gift .. It is amazing and fascinating
Best Regards
You are welcome, glad I can help.
Regards
Originally Posted by YasserKhalil
Please Login or Register to view this content.
Thank you very much for all this great and continuous help
Now it is perfect
Kind Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks