From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Work with MAX, MAXIFS, LARGE, and related functions

Work with MAX, MAXIFS, LARGE, and related functions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Work with MAX, MAXIFS, LARGE, and related functions

- [Instructor] Excel has 2 over a hundred different statistical functions. 3 If you're looking for them and going to the formulas tab, 4 initially you don't see that category here, 5 but it's listed under more functions 6 and there's statistical, 7 and as I suggested, quite a few 8 of them, well over a hundred here. 9 Now, some of the most commonly used ones are max and min, 10 but there are some others as well too. 11 If we want to know what the highest compensation amount is 12 in this list, we could certainly sort the data, 13 but we want to keep it in its current order. 14 It's alphabetized by name, we don't really need 15 to sort it anyway, 16 but we want to know what the highest compensation amount is 17 equal max. 18 And in this example here, we're going to click column E 19 because there's nothing else in column E 20 except those numbers in the title on top. 21 If a list like this had interim totals 22 and a total…

Contents