MS Excel | Max, Min, Large and Small 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.