Dueling Excel 111


Slowest Time That Is Within 2 Seconds Of The Fastest

DESCRIPTION

See Mr Excel and excelisfun use two methods to find the Slowest Time That Is Within 2 Seconds Of The Fastest:
1) Mr Excel: 2 D Functions and a Data Table
2) Excelisfun: Excel 2010 AGGREGATE function with array calculations and MAX and MIN functions with the IF function and an array calculation.

WORKBOOKS




Be the first to comment

Leave a Reply