Bored at work? Make some nuz...
DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact | Forum

Mixed sets displayed in seperate cells

View: New views
2 Messages — Rating Filter:   Alert me  

Mixed sets displayed in seperate cells

by gamblingaddict;) :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,
 I was wondering if the mix sets feature can produce the results in seperate cells rather than all one long number in column A.

Example,

Set 1 - Set 2 - Set 3
1            2        3
4            5        6
7            8        9

Result =
A

123
126
129
153
etc.

Prefered Result =
A     B    C
1     2    3
1     2    6
1     2    9
1     5    3
etc.

Any ideas? Thanks.

Re: Mixed sets displayed in seperate cells

by DigDB Support :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Can you use DigDB->Column->append... to append "-" to set1 and set2 and set3, then in the mixed result, split the column A by "-"?

If "-" is used in the data, change it to some random texts which you can split later.

If set1 is not a column, select the set1 cells, then use DigDB->Selection->Copy Cells into one column


Features | Testimonial | Download | Purchase | FAQ | License | Contact | Forum (powered by Nabble's free forum)

Copyright © 2006 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.