LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 67
Default Earliest/Latest Date Query

I'm sure there must be a simple way of doing this ...

I have 2 columns of data:

A1:A2000 contains data of vehicles used to transport goods
B1:B2000 contains the dates on which each vehicle was used over the space of
several years

There are many duplicate entries in each column (ie; one particular vehicle
will appear many times as will any given date).

I simply need to set-up a summary that shows:

1) The total number of times each vehicle was used
2) The earliest date each vehicle was used
3) The latest date each vehicle was used

I have resolved 1) using SUMPRODUCT but can't at the moment work-out the
answer to 2) and 3). VLOOKUP comes to mind but maybe there is another
SUMPRODUCT solution?

Thanks for any help.


 
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
Looking for the earliest/latest date in a column soconfused Excel Worksheet Functions 3 July 31st 07 08:36 PM
Calculating earliest start and latest end dates by contract Data Analyst Excel Worksheet Functions 4 June 4th 07 11:23 PM
How do I find the earliest date? Dave Shultz Excel Discussion (Misc queries) 1 May 11th 07 06:45 PM
Query Latest Date Mack Neff Excel Discussion (Misc queries) 1 April 26th 07 07:42 PM
Earliest and latest dates that can be correctly represented in Exc Kitten Excel Discussion (Misc queries) 2 April 20th 07 05:16 AM


All times are GMT +1. The time now is 09:30 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"