MS Excel | Max, Min, Large and Small functions

This video covers the Max, Min, Large and Small functions and how to use it in Excel. These are used when you want to determine the biggest or smallest number in a range or the specific smallest or largest (example sixth smallest) in a range.
#MrLongEducation #Excel #Functions

[@andreausa123]

Very clear , thank you Sir !

[@mohamedmeshref]

💓💓💓Unbelievable way of explanation.. This the first time to see a video with such ability to explain the idea in that smart way.. 🤚 But we need some Excel files to apply your videos on it...

[@MrLongITandCAT]

Hi. I have video on practical examples. You can use the following document to download the data files and questions for the practicals tinyurl.com/mrlongexamguide2023cat

[@mohamedmeshref]

@@MrLongITandCAT Thank you very much.. that was very helpful.. But to be more specific, can you put in the description below the video, a link to the file you are using in this specific video?

[@darbycarpenter3032]

I have a stock chart of the S&P 500 that has 500 rows. Is there a way to use this function so that it returns what cell the answer is in rather than having to find it in the chart after the answer is provided?

[@MrLongITandCAT]

You need a combination of the Max, Match and Address formula. Here is a link to an example that may help www.excel-easy.com/examples/locate-maximum-value.html If you still need help, then let me know and I can try explain how to use these formulas in your example. Hope it helps.

[@bleytensmit107]

For top and bottom...you press F4 for dollar sign correct?

[@MrLongITandCAT]

You press F4 to insert the dollar symbols for absolute cell referencing.