Avatar of tjoconnor
tjoconnorFlag for Ireland

asked on 

Excel Formula to find Earliest Date

Hi All,

I was wondering if you could help me with an excel formula.

I have 3 columns of data.

1) Column 1 = Device Name
2) Column 2 = Application Name
3) Column 3 = Application Installation Date


I would like a formula to return the Device Name and the Earliest Application Installation Date on that Device.  So form the attached file the formula should return 3 rows

Device 1 05/05/2005
Device 2 03/03/2003
Device 3 16/02/2001

I have been playing around with the small function and that will return the lowest date in a range. However I need  the lowest date for each device and I cant seem to tie that formula to each device as well.

Any help would be greatly appreciated
excelearliestdate.xlsx
Microsoft ExcelMicrosoft OfficeSpreadsheets

Avatar of undefined
Last Comment
tjoconnor
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

If you are just wanting a single occurence of the formula, you can use the DMIN function:

=DMIN(Database,Field,Criteria)

Database - table of data
Field - the field that you want returned
Criteria - a separate list specifying the criteria, in your case it would just be Device name. This list has to have a header the same as the Database list.

Alternatively, run a pivot table and drag the date as a value field and use the Min option to Summarise.

Thanks
Rob H
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of tjoconnor
tjoconnor
Flag of Ireland image

ASKER

thanks a million for all your help. These worked great
Microsoft Excel
Microsoft Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo