Join Dennis Taylor for an in-depth discussion in this video Work with MAX, MAXIFS, LARGE, and related functions, part of Excel Tips Weekly.
- [Instructor] Excel has over 100 different…statistical functions.…If you're looking for them in going…to the Formulas tab, initially you don't see…that category here.…But it's listed under More Functions…and there is Statistical.…And as I suggested, quite a few of them,…well over 100 here.…Now some of the most commonly used ones are…Max and Min but there are some others as well, too.…If we want to know what the highest compensation amount is…in this list, we could certainly sort the data,…but we want to keep it in this current order.…It's alphabetized by name.…We don't really need to sort it anyway…but we want to know what the highest compensation amount is.…
Equal max.…And in this example here we're going to click column E…because there's nothing else in column E…except those numbers and the title on top.…If a list like this had interim totals…and a total on the bottom, we'd have to reconsider…your use of this.…It might not work at all if you've got…a lot of totals within it.…The example here, we're all set,…we don't have to type that right parenthesis.…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.