I'm going to show you how I did this worksheet what I've done is I have
sorted by the marks so that could be sorting by a price or it sorting by any
finger and then I've ranked the highest the highest mark as number one and the
lowest mark as the highest number so this is how I did it
the first thing I did is I named the range marks so the B column I named I
named marks so let's just go here and you can see that it's the marks range
and so that's where I've defined my formula and now I have I've made made
this so that it works on this sheet so when you activate the sheet it will work
so let's enter some new characterized
okay and let's say 79 so that's what his mark mark is now and so now let's go off
the sheet and come back on the sheet so when you come back on the sheet you see
that rocky racoon has a 79 it's sorted and he's ranked number-five now so let
me show you how I did it so to do it for an activated sheet what I did is I right
clicked on the sheet and we're gonna go view code and what I've done is I've
I've selected worksheet and activate meaning basically if you go off a sheet
and come back on the sheet its gonna run and the privates out now I've defined as
my last row as long and my last row was active sheet cells one one current
region rows count and so my range is a two because where I got header rolls to
see in the last row select and then this is active workbook sheets one auto
filter this is basically all the steps for for sorting your data basically it's
turning on the auto filter and then it sorting your data and then you're
turning off the autofill so by by saying the statement again now what I did after
I've done that is I'm setting up a ranking so range C to select active
formula equals now because this is an is a worksheet function I have a double a
double equal sign here so this is basically a formula rank average so it's
b2 and Marx is my defined range which is the B column and it's zero so if one
would be going ascending so the lowest number would be one but I want the
highest number so it's zero okay and then I go range to select and then I'm
going to drag this down so I selection autofill destination range c2 to see
last row and then this is Phil normal and then we're gonna so that we can see
it we can go range c2 to see last row dot select and then we're going to go
back in case we get to have a huge long list we're gonna go right back up to the
top of the list so range C to select and then n sub enter now here I can for
example I can change this around and I can have ones that are in place and
we'll just put in a 67 for Joe Blow and it will change the ranking but when you
go off and come back on it has changed its changed the order for you here too
so this is how you sort by numbers and then we'll put a ranking on these
numbers please subscribe