Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenation problems...
Hi I've been trying to figure out an efficient code to solve this challenge: *Step1:* I make a random selection of cells *Step2:* The Vba code loops through every cell of this selection, and extracts only cells with unique values. *Step3:* These unique values are assigned to one cell ( ex. A1 ), separated with commas - 123,456,789 aso.... also - I need all the unique values concatenated into one string, separated with commas. I really hope someone can help me out on this......... Hojo Norway -- hojo ------------------------------------------------------------------------ hojo's Profile: http://www.excelforum.com/member.php...o&userid=30082 View this thread: http://www.excelforum.com/showthread...hreadid=497622 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenation problems...
I have an Addin that does exctly that (along with a bunch of other stuff).
Send me your e-mail address and I will send you the addin... -- HTH... Jim Thomlinson "hojo" wrote: Hi I've been trying to figure out an efficient code to solve this challenge: *Step1:* I make a random selection of cells *Step2:* The Vba code loops through every cell of this selection, and extracts only cells with unique values. *Step3:* These unique values are assigned to one cell ( ex. A1 ), separated with commas - 123,456,789 aso.... also - I need all the unique values concatenated into one string, separated with commas. I really hope someone can help me out on this......... Hojo Norway -- hojo ------------------------------------------------------------------------ hojo's Profile: http://www.excelforum.com/member.php...o&userid=30082 View this thread: http://www.excelforum.com/showthread...hreadid=497622 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenation problems...
Shure, here it is..... 'hojo' ) Hoj -- hoj ----------------------------------------------------------------------- hojo's Profile: http://www.excelforum.com/member.php...fo&userid=3008 View this thread: http://www.excelforum.com/showthread.php?threadid=49762 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation help | Excel Worksheet Functions | |||
Concatenation | Excel Discussion (Misc queries) | |||
Help with Concatenation | Excel Worksheet Functions | |||
Concatenation | Excel Discussion (Misc queries) | |||
Concatenation using IF AND - Possible? | Excel Worksheet Functions |