Got any Excel/VBA Questions? Free Excel Help
ktaylor wanted a formula method for finding the oldest (lowest) date out of a list of dates in a column.
Egad suggested the following solution providing the date range was in cells A1:A30
=SMALL(A1:A30,1) will return the smallest (oldest) date or number.
=SMALL(A1:A30,2) will find the second smallest….and so on
Epidemic suggested using one of the MIN MAX and MEDIAN functions.
An example would be
|Excel VBA Macro - Adding Conditional Page Breaks|
|Excel: Summing/Counting Based on Multiple Criteria|
|Excel Controls From the Forms Toolbar and Controls from the Control Toolbox Toolbar. Which Type to Use?|
|Excel Custom Number Formats|
|Excel Dates and Excel Times|
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.