The expression in A1 references the value in the totals row for the Order column. That value is the result of a special SUBTOTAL () function that returns the maximum value in the filtered set.

3] To Find the Maximum Value Choose the cell below or right, then go to the Auto-Sum Tool in the Editing Group and select the Max Function; it will automatically give you the result.

Modern C++ How To Write a Function That Returns More Than One Value Like magic, tuples make the impossible possible. Yep, we're talking here about one little corner in the Standard Template Library ...

Just to let you know, if you buy something featured here, Mashable might earn an affiliate commission. Gone are the days when Microsoft Excel held a monopoly over the spreadsheet world. Google ...