Re: Get "the oldest date only" in EXCEL

["rick baird" <rick.baird@xxxxxxxxx>]

oldest date by whatever field ABC123 is or just the oldest date in the
entire sheet?

if by ABC123, you can create a pivot table (data menu / pivot table), but I
think you'll have to recreate it every time the source data changes.

On 6/6/07, Peter Vidal <Peter_Vidal@xxxxxxxx> wrote:
> Hi list:
>
> I have rows of data in a worksheet:  items, dates and quantities.  My
> items are sometimes repeated in the list because I have different days,
> let's say:
>
> ABC123      1051215    10.000
> ABC123      1060122     5.000
> ABC123      1070330    17.000
>
> I just want to keep in a clean worksheet the record with the "oldest
> date", in this case, the first line.
>
> Is that possible in EXCEL 2000?
>
> Note: I can't use SQL on his laptop.  Is very outdated and we need this
> fast.
>
> Thanks in advance.
>
>
> Peter Vidal
> PALL Corporation / SR Programmer Analyst, IT Development Group
> 10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
> http://www.pall.com
>
> "Truth is not always popular, but it is always right."
> Anonymous
>
>
> --------------------------------------------------------------------------------
>
> Attention:
>
> This communication may contain information that is confidential,
> privileged and/or exempt from disclosure under applicable law.
> If you are not the intended recipient, please notify the sender
> immediately and delete the original, all attachments, and all
> copies of this communication.
>
>
>
> --------------------------------------------------------------------------------
>
> --
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing
> list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.