max,min & avg value output

[anubhav87]

Hi Experts

I need to get min, max & avg. value out of certain range by applying custom filter on the range and the output can be displayed in other new excel sheet. If anyone can help me out in this regard.

[oeldere]

You can use pivot table to get those info.

[anubhav87]

I need to perform this using macro, each time i can run macro and get values as output.
I have made macro to apply custom filter now i need to get the max, min, avg value out of the specific range.
PROBLEM IS THAT :: when i extract max value out of column(having custom fiter) , it is giving me max value of the complete column irrespective of applying custom filter.
Pls help me in this regard.