Formula to select Highest Number or VBA to select last cell from filter.

[VBA learner ITG]

Good morning my peers,

I was wondering if you could advise if there is a formula or VBA code that can be used for my issue.

I have a database that once is filtered i would like to select the largest number in the filtered data of column G and populate cell a1.

Is that possible by formula or VBA code?

 

[BrianJN1]

You give too little information for what you ask.
Please be more direct and then someone may be able to advise.

 

[VBA learner ITG]

found a solution to my issue by a formula.

Took me a week of searching on the internet and after 5 mins of posting on here got a solution (typical)

I HOPE THIS HELPS ANYONE READING MY POST AND ANYONE ELSE IN THE SAME POSITION.

Min value in range =

• =SUBTOTAL(5,C2:C10)

Max value in range =

• =SUBTOTAL(4,C2:C10)