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
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.
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 a million for all your help. These worked great
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.
=DMIN(Database,Field,Crite
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