From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales

Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales

“

- [Instructor] In this worksheet, 2 we've been tracking sales over a 10-year period. 3 We've got a chart off to the right 4 that also brings out the data in a more colorful way. 5 In column B, we're showing the sales, 6 column C was put in manually, 7 where we're using the word highest, 8 followed by a number to indicate whether it's the first time 9 that it's the highest, second time, third time, et cetera. 10 We'd like to continue using this worksheet, 11 but rather than putting in the entries 12 in column C manually, 13 we want to do this by formulas. 14 Let's first zoom in on the list here. 15 I'll hold down Ctrl and Alt, 16 press the plus key a few times. 17 One of a number of different ways to zoom in. 18 And let's just start with a simple formula in column D here, 19 a simple check to see if the current sales entry 20 is the highest. 21 So, in our formula here, 22 we'll be using three functions ultimately…

Contents