How to find and use the maximum value in VBA code

[alihadi]

Hi, How to find and use the first maximum value if we have more than one with the same value using VBA programme? any assistance is appreciated.

[PAB]

Hi alihadi, that's spooky for Friday the 13th, there is virtually the exact same question been asked a couple of threads down from this one, spooky or what?

[alihadi]

Sorry, do you know how to choose the first Max value if we have more than one with the same value?

[PAB]

Give this a go...


=LARGE(A1:Z50,1)

Change the range to suit.

I hope this helps!

[SamT]

Is this for homework or for production? It will make a difference in how I answer.