Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Bl3:M25 shows 5 sales by reps in various months. For example, D15 has Cal's sales in March. 313:325 has all ofJanuary sales bythe various reps.
Bl3:M25 shows 5 sales by reps in various months. For example, D15 has Cal's sales in March. 313:325 has all ofJanuary sales bythe various reps. C13:C25 has all of February sales by the various reps, etc. Enter a formula in 329 to rank 813 in the column range 313:325. In other words, your formula must rank Ann's January sales in the range of all January sales. If the rank formula gives an error, the display must be "No Rank". Copy B29 down and right to show the ranks for other reps and months. Your formula in 329 must be such that it can be copied. Hint: The image near 023 shows part of the solution. \f\f
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started