Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looking for the earliest/latest date in a column | Excel Worksheet Functions | |||
Calculating earliest start and latest end dates by contract | Excel Worksheet Functions | |||
How do I find the earliest date? | Excel Discussion (Misc queries) | |||
Query Latest Date | Excel Discussion (Misc queries) | |||
Earliest and latest dates that can be correctly represented in Exc | Excel Discussion (Misc queries) |