Rank data with the RANK and RANK.AVG functions

- [Instructor] If we wanted to rearrange this list…in columns A through E based on salary,…we could certainly sort the list…and see how the salaries rank.…But sometimes we want to keep the list in a certain order.…We're concerned about other data here.…We want the ranking to always be part of the record.…And the data will change.…So imagine the salaries will change.…But how do we calculate the rank here?…Well, fortunately, we don't really have to calculate it.…We've got a function.…And as we start to type rank,…you'll notice that there are actually three functions.…RANK and RANK.EQ are identical.…

Probably in future versions of Excel,…there will no longer be a RANK but there will be a RANK.EQ.…Let's use this one.…The salary in question is the one right here in E2, comma,…and we're comparing that with other entries.…And where are the other entries?…They're all in column E.…Now this looks like it could be an illegal reference…'cause we're overlapping, but it isn't.…Now I can press Enter and get an answer.…But you'll notice there's another option out here.…