Re: sorting data
From: Dave Peterson (ec35720_at_msn.com)
Date: 10/21/04
- Next message: Mick: "Excel trys to open a file twice"
- Previous message: Dave Peterson: "Re: NAMED Custom Number Format"
- In reply to: Ivan: "sorting data"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 21 Oct 2004 17:10:31 -0500
How about this:
(I'm gonna assume that you have headers in row 1)
Insert a new column A.
In the new A1, put:
Min Date
In A2, put this formula:
=TEXT(MIN(IF($B$2:$B$30=B2,$C$2:$C$30)),"yyyy/mm/dd")
Adjust 30 to your last row.
But hit ctrl-shift-enter (instead of just enter).
This is an array formula and if you do it correctly, excel will wrap your
formula with curly brackets {}.
Drag it down your range.
Now sort by the min date field with a secondary sort of Product number and a
tertiary sort of production date.
(You can delete column A if you want when your done--or keep it if you need it
later.)
Ivan wrote:
>
> I have a particular sorting requirement I need help with.
>
> The spread sheet is very simple, basically an inventory file with columns
> representing the following data:
> Column A: five digit product number
> Column B: the production date of that product
> (there are other columns representing information that is irrelevant)
> The report contains several hundred rows of entries.
> Individual product numbers are entered several times with as many different
> production dates.
> I must use this data to create a report that is sorted FIRSTLY by
> production date in ascending order.
> However, all product numbers must be contingent. That is to say that when
> the first date of a particular product number comes up all the remaining
> entries for that product must follow.
>
> Is there a way? Sorry for the naive question. I'm just a warehouse grunt.
> Ivan
-- Dave Peterson ec35720@msn.com
- Next message: Mick: "Excel trys to open a file twice"
- Previous message: Dave Peterson: "Re: NAMED Custom Number Format"
- In reply to: Ivan: "sorting data"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
