Each journey starts with ..... HELP!

[shaddy]

Hi,

I am hoping one you of you extremely clever types can start me on an
Excel journey. I have been tasked with preparing a 'best of day/month'
sales sheet covering 24 stores in my locale. The problem I have is how
to formulate a ranking process i.e

1 2 3 4 5 6
7 etc.

Store Daily Rank Margin % Rank Turn $ Rank
sales

I need to rank each aspect, weighting certain areas (x 2), and then
give an overall sort by best standing. My problem is how to
differentiate the rank of each column from highest to lowest. Once I
sort that out, I need to award a rank position in the following column,
sort out the ranking of the next column, rank accordingly until at the
end I can sort by total ranking points each days overall best store.
This cannot be as difficult as seems to me, but in all honesty, my
brain is in fade mode and I cannot see a solution.

I would be much obliged if someone can point me in the right
direction.

Many thanks in advance

Keith C

 

[shaddy]

Hmm maybe i did not explain myself well enough to generate a reply. In
brief, my first obstacle is how do I get a column of figures to
'autorank' i.e.

store/sales/rank
1/100/3
2/120/2
3/150/1
4/90/3

The sales will be a manual input, but I would like the rank column to
issue a rank point (highest to lowest) against each sale total. I will
ultimately have 16 columns to rank, covering 24 stores (lines) with a
final column stating the winner for the day overall.

Again, if anyone can point me in the right direction I would be most
pleased (as will my boss who thinks this should be easy for me!)


Keith C

 

[Intruder9]

Good morning Keith, you probably did explain yourself in your first post but
something you need to understand, no one is appointed to this group and we
all have a life, its Sunday alot of us go to Church, most of the time
someone gets back to you within minutes, sometimes days, patience is
everything. Go to this link to see if it will give you the help you need
http://www.cpearson.com/excel/rank.htm also you could do a search of the
archives on Google with group:*Excel* insubject:rank on this link
http://groups.google.com/ Good luck and remember patience is everything!!

 

[shaddy]

Many thanks for the help

Of course you are right, patience is everything - my dilemma is not
everyone elses catastrophe - thank you for reminding me.

Again thank you for the direction

 

[Earl Kiosterud]

Shaddy,

=RANK(B2,$B$2:$B$5)

Copy down with Mr. Fill Handle or with Copy/Paste. It should yield the rank
of each sales amount, resulting in 3,2,1,4. You can now sort on that
column.