Ranking Colums???

[Dr,Bob]

I have a spread sheet I use to count parts lets say 15 different parts I
need to list them in order a certain order by the part number and the order
can not change.
column B has a formula which gives me the total number of parts used (adds
d1 to k1)
I need column C to show the rank of the part for that row and not change the
order of the part numbers. Is there a formula that will show in column C as
1 being the most common used part & 15 the least? Thanks in advance

 

[Bob Buckland ?:-\)]

Hi Bob,

You may want to post this in the Excel newsgroup (link below)
and include the version of Excel you're using.
The information in Chip Pearson's page on ranking here
may be helpful to you
http://www.cpearson.com/excel/rank.htm

===========
I have a spread sheet I use to count parts lets say 15 different parts I
need to list them in order a certain order by the part number and the order
can not change.
column B has a formula which gives me the total number of parts used (adds
d1 to k1)
I need column C to show the rank of the part for that row and not change the
order of the part numbers. Is there a formula that will show in column C as
1 being the most common used part & 15 the least? Thanks in advance >>


--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://communities2.microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel
B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[Dr,Bob]

opps wrong group sorry about that I did figure it out so no need to answer

thanks anyway