Our solution will be to create in column C a formula using the RANK function. The problem is that if we were to copy new values into the data set, the “helper column” would no longer be accurate. It would be easy to sort the list by sales and then create a “helper column” of numbers that count from 1 forward. Using our previously examined list of sales managers and sales, we want to create a ranking of the sales in column C, but we do not wish to sort the original data.
0 Comments
Leave a Reply. |