Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

finding max to min values in a range

0

I need to identify the max fvalue in a range, then the enxt highest value, then the next highest, etc. in order to input elsewhere in a file....

for example:  2400 4150 3900 6300

Is there a simple method or formual to use?

Many thanks.

excel
MS Office Version: 2016
posted by: Cam on Fri Jul 7, 2017 at 5:09 pm
Answer
Discuss

Discussion

Please don't forget to select the answer that worked best for you! Just click the Select Answer button at the bottom of the desired answer.
don (rep: 1989) Jul 10, '17 at 6:55 am
Add to Discussion

Answers

1
=Large(A$2:A$40, 1)
will return the highest number in the range A2:A40. Modify the last value to 2, to return the second largest etc.
posted by: Variatus (rep: 4889) on Sat Jul 8, 2017 at 1:49 am
Discuss

Discussion

Thank all who answered; so simple.....
Cam Jul 8, '17 at 6:26 am
If you benefited from the answer, plese mark it as "accepted" as a help to others who would otherwise waste time.
Variatus (rep: 4889) Jul 8, '17 at 10:25 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login