which formula to use for automatic ranking status

Status
Not open for further replies.

mooney0001

New Member
Joined
Oct 26, 2006
Messages
2
Could you tell me the formula to use in ranking, i will specify, on the spread i have multiple rows with names, based on 2 totals example Total P and Total bb these totals will determine the rank of names and automatically put the names in order according to the to totals, the total for P is manually put in and the total for bb is manually put in.
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi, mooney0001
Welcome to the Board !!!!!

did you try SORT: see the menu Data

kind regards,
Erik
 

Barry Katcher

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
Hi, mooney. Welcome to the Bored.

As Erik suggests, Sort seems to be the Tao; either manually or via a macro.

But, if you have the numbers in two different columns, that may present a problem. Would the same row have numbers in both columns? If not (if one cell has a number and the other one has zero or is blank), then use a new column and add the two cells together, then sort on that column.

It would be helpful if you could give us some sample data, and how you would like the data to be arranged after the sort.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
I just discovered this is a duplicate thread
check the boardrules
http://www.mrexcel.com/board2/viewtopic.php?t=131687
Can you image how frustrating it can be trying to solve a problem for somebody and then find out that what you were attempting was already answered in another post by the same Original Poster?

why did you repost the question ?
http://www.mrexcel.com/board2/viewtopic.php?p=1151592&highlight=#1151592
if you do not get replies you can always add some information replying to your own question
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,113,856
Messages
5,544,690
Members
410,629
Latest member
foozen
Top