rearranging data within an array 
Author Message
 rearranging data within an array

I am looking for a function that will rearrange a list of dwgs and their

groupings
and place them in another area automatically without repeating.....

example:

order#    dwgname        moved to:     order#   dwgname
1111        tree                                     1111         tree
2222        box                                     2222         box
2222        box                                     2222         ball
2222        ball                                     3333         pencil

3333        pencil

If you have anything that could come even close to helping me....
I would greatly appreciate it,   'cause I have no clue.....



Wed, 18 Jun 1902 08:00:00 GMT  
 rearranging data within an array


Quote:
> I am looking for a function that will rearrange a list of dwgs and
their

> groupings
> and place them in another area automatically without repeating.....

> example:

> order#    dwgname        moved to:     order#   dwgname
> 1111        tree                                     1111         tree
> 2222        box                                     2222         box
> 2222        box                                     2222         ball
> 2222        ball                                     3333
pencil

> 3333        pencil

> If you have anything that could come even close to helping me....
> I would greatly appreciate it,   'cause I have no clue.....

I'm not sure what you mean by 'rearrange' but their is a built in excel
function that will do exactly what you need!  The feature is called
Advanced Filter and is found under the Data...Filter... menu.  What you
need for this to work is to highlight the heading of your list (order#,
dwgname) and copy it to another location.  This will become your
criteria.  So, for instance, if your original list is located in A1:B6
you would take A1:B1 (your heading) and copy it to, let's say D1:E1.
Now, make sure you highlight your original list and go to
Data...Filter...Advanced Filter and click Copy To Another Location.  Set
the List Range to A1:B6, set the Criteria Range to D1:E2 (make sure you
have it at E2 not E1), and set the Copy To to, let's say, G1.  Also,
because you want a unique list, check on Unique Records Only.  Hit OK
and watch the magic happen.

For a more detailed, albeit confusing, explanation, read the help file.
--
-Jamie Weinstein, Senior Programmer Analyst
Morgan Stanley Dean Witter, Investment Banking Division
1585 Broadway, 34th Floor
New York, NY 10019

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT  
 rearranging data within an array
That does do it once...
but I need it to do it automatic....and without copying the cells
formats-just the data.....
but thanx anyway....
Quote:



> > I am looking for a function that will rearrange a list of dwgs and
> their

> > groupings
> > and place them in another area automatically without repeating.....

> > example:

> > order#    dwgname        moved to:     order#   dwgname
> > 1111        tree                                     1111         tree
> > 2222        box                                     2222         box
> > 2222        box                                     2222         ball
> > 2222        ball                                     3333
> pencil

> > 3333        pencil

> > If you have anything that could come even close to helping me....
> > I would greatly appreciate it,   'cause I have no clue.....

> I'm not sure what you mean by 'rearrange' but their is a built in excel
> function that will do exactly what you need!  The feature is called
> Advanced Filter and is found under the Data...Filter... menu.  What you
> need for this to work is to highlight the heading of your list (order#,
> dwgname) and copy it to another location.  This will become your
> criteria.  So, for instance, if your original list is located in A1:B6
> you would take A1:B1 (your heading) and copy it to, let's say D1:E1.
> Now, make sure you highlight your original list and go to
> Data...Filter...Advanced Filter and click Copy To Another Location.  Set
> the List Range to A1:B6, set the Criteria Range to D1:E2 (make sure you
> have it at E2 not E1), and set the Copy To to, let's say, G1.  Also,
> because you want a unique list, check on Unique Records Only.  Hit OK
> and watch the magic happen.

> For a more detailed, albeit confusing, explanation, read the help file.
> --
> -Jamie Weinstein, Senior Programmer Analyst
> Morgan Stanley Dean Witter, Investment Banking Division
> 1585 Broadway, 34th Floor
> New York, NY 10019

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Setting Data within an array in code directly

2. Rearranging Array's Rows

3. returning a smaller array from within a larger array

4. Is Array within Array possible?

5. HELP: Rearranging Row Data into Column Data

6. rearranging numbers within a field

7. rearranging data on a spreadsheet

8. Rearranging data from rows to columns

9. Rearranging Cell Data

10. Possible code to rearrange to a data table for charting


 
Powered by phpBB® Forum Software © phpBB Group