Difference Between 2 Highest Figures when Filtering

@cbatrody

Copy and paste the list into a worksheet and use the data column to columns feature to get the three columns using space as a separator: takes less than 10 seconds. ;-)

What you are trying to do, can be achieved with the help of formulas. Find the attached sheet to see if this fulfills your requirement. The attached workbook has two sheets "Data" and "Filter". The data sheet contains your raw data and in filter sheet you can filter data with the help of formulas. The formulas in the filter sheet are such that if you input more data in Data sheet, it will be reflected in the filter sheet. You can increase the range in the formula if needed in future.
Hope this helps.

Find the attached workbook.

As I said this can be achieved with the help of formulas.
On the Filter sheet, there is a drop down list in cell B2 to select vehicle type.
The workbook has total four formulas on Filter sheet. One Array Formula in cell A5 and three regular formulas in the cell H5, J5 and L5 for MAX, MIN and AVERAGE respectively.
Steps to apply these formulas on Filter sheet are as follows...

On Filter sheet......

In cell A5
Copy the formula given below --> Select cell A5 -->Press F2 (function key)--> Ctrl+V to paste the formula --> hold down the Ctrl + Shift and then press Enter. Grab the fill handle of cell A5 (bottom right corner of cell boudary of A5) and drag it up to E5 --> While A5:E5 range is still selected, grab the fill handle of cell E5 (bottom right corner of cell E5) and drag down up to E100.
This way the array formula will be applied to the range A5:E100. Now format the col. A as Date. The array formula is.....

=IFERROR(INDEX(Moomba!A$9:A$5000,SMALL(IF(Moomba!$B$9:$B$5000=$B$2,ROW(Moomba!$A$9:$A$5000)-ROW(Moomba!$A$9)+1),ROWS(A$5:A5))),"")

In cell H5, place the formula given below (For MAX)

=LARGE($C$5:$C$100,ROWS(H$5:H5))

and drag down to H6.

In cell J5, place the formula given below (For MIN)

=SMALL($C$5:$C$100,ROWS(J$5:J5))

and drag down to J6

In cell L5, place the formula given below

=AVERAGE($C$5:$C$100)

And that's it.

Hope this helps.