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.