Category Archives: excel function

Excel: Using the MAX() and MIN() Functions

Want to find the highest or lowest values in the a range in Excel? Then there are two functions that are easy to use to do that. They are MAX(), for finding the highest, or maximum value, and you guessed … Continue reading

Posted in Excel, excel function, Excel Functions, Microsoft 365, Microsoft Office | Tagged , , , , , , , , , | Leave a comment

Excel: Using the LARGE() and SMALL() Functions

If you have been using Excel you have probably come across the MAX and MIN functions for finding the highest or lowest values in a range. But what if you want to find the second largest or third and so … Continue reading

Posted in Excel, excel function, Excel Functions, Microsoft 365, Microsoft Office | Tagged , , , , , , , | Leave a comment

Excel’s Newest Function XLOOKUP

VLOOKUP and HLOOKUP are two popular functions in Excel and a new one has come along to replace them, don’t worry they haven’t gone away. The new function is XLOOKUP it is easier to use and has some additional features … Continue reading

Posted in Excel, excel function, Microsoft Office | Tagged , , , , , , | Leave a comment