Max Values from Filtered Information - Excel

[Glen_1066]

Hi, I have an Excel spreadsheet that has some data filtered out. When I try to find a 'MAX' value from one of the columns, the result includes values from the data that has been filtered out. How can I find a max value from the data included within the filter only?

KR, Glen

[#2]

@Glen_1066 

Check out the SUBTOTAL function.

SUBTOTAL function - Microsoft Support