LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default How can I find the minium date in column B subject to data in Colu

I want to select the minium date in column B (excluding blanks) and subject
to matching a document type listed in Column A. How can I do this

A B
ABC 28/10/06
ABC 01/01/07
ABC
ABC 25/07/07
ADE 15/05/07
ADE
ADE 28/02/07


Desired Result (separate worksheet)
A B
ABC 28/10/06
ADC 28/02/07

Thanks

--
Gwyn
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find the most recent date in a column based on other column Veretax Excel Worksheet Functions 7 October 18th 06 05:01 PM
Taking a remainder amount from a column and adding it another colu Help for Jason Excel Discussion (Misc queries) 0 August 2nd 06 05:46 PM
Need help to find a date (latest date) from a column Max Excel Worksheet Functions 0 March 20th 06 02:49 PM
How to find avg, min & max for grading subject Param Excel Worksheet Functions 2 March 17th 06 08:04 PM
When I change the style in column (a) a date, it also changes colu Wayne Excel Discussion (Misc queries) 4 January 31st 05 03:05 PM


All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"