HOW CAN I SORT A "RANKED" COLUMN WITHOUT LOSING THE FORMULA?

D

dbgskid

I have created a ranking sheet for sales performance that automatically ranks
based on sales numbers. The rank formula works fine, but when ever I try to
sort the data based on the numeric ranking the formula in the column loses
its integrity.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ranking Sales Reps 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Detemine sales order based on plac changes and not sales figures -mathmatic problem to solve 1
Rank order with conditions 3
Ranking - Not Sorting Properly. 16
How to Rank Name? 4
Current Region in a formula 1
Weighted ranking of a series 3

Top