Re: Get "the oldest date only" in EXCEL

[Peter Vidal <Peter_Vidal@xxxxxxxx>]

"I believe you are looking for the Min() function:
MIN(number1,number2, ...)"

But isn't this approach helping me to determine ONLY the oldest (minimum) 
value?  I know how to get that.  The beauty is to KEEP the rest of the 
information that is associated with this value.

That is the key.


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

"Sometimes your JOY is the source of your smile, but sometimes your SMILE 
is the source of your joy."- 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.


--------------------------------------------------------------------------------