Hello All,
I am looking for a way to Concatenate only unique visible cell values, I found a module online that solves 90% of the problem but it is not unique. Id gladly pay (tip) for a solution with paypal.
Listed below was that module i found online
Please Login or Register to view this content.
Last edited by 6StringJazzer; 03-22-2020 at 04:17 PM.
try this code:
P.S. please follow the rules about using BRACKETS to enclose your code. Use the # button in the menu like I did.Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
We do not allow offers of payment through third-party services. If you want to offer payment, purchase points through our forum and post your question on our Commercial Services forum (FAQs).Originally Posted by partyguy1516
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
@p24leclerc,
Just noting that if the first cell in the specified range is blank, the text your function returns will display the specified delimiter at the beginning.
@partyguy1516
I think this function should work for you...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks