View Full Version : How to find and use the maximum value in VBA code
alihadi
05-13-2016, 03:47 AM
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.
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
05-13-2016, 03:58 AM
Sorry, do you know how to choose the first Max value if we have more than one with the same value?
Give this a go...
=LARGE(A1:Z50,1)
Change the range to suit.
I hope this helps!
Is this for homework or for production? It will make a difference in how I answer.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.