software

I would like to orrange the names in order of sales then days work then
priorityname priority days work sales
bob 1 1 3
pete 3 1 3
jane 2 2 5
jill 5 3 5
terry 4 1 4

the results would be

Jill
Jane
Terry
Pete
BobIve been given some tips of the rank function but havnt managed to work
out how best to use it for my purpose.--
ceemo
------------------------------------------------------------------------
ceemo's Profile: www.excelforum.com/member.php...oamp;userid=10650
View this thread: www.excelforum.com/showthread...hreadid=534349Won't SORT work for you?
A recorded macro

Sub Macro4()
'
' Macro4 Macro
' Macro recorded 4/19/2006 by Don Guillett
'

'
Range(quot;A27quot;).Select
Selection.Sort Key1:=Range(quot;D3quot;), Order1:=xlDescending,
Key2:=Range(quot;C3quot;) _
, Order2:=xlDescending, Key3:=Range(quot;B3quot;), Order3:=xlDescending,
Header _
:=xlGuess, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom _
, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal,
DataOption3:= _
xlSortNormal
End Sub

--
Don Guillett
SalesAid Software

quot;ceemoquot; gt; wrote in
message ...
gt;
gt; I would like to orrange the names in order of sales then days work then
gt; priority
gt;
gt;
gt; name priority days work sales
gt; bob 1 1 3
gt; pete 3 1 3
gt; jane 2 2 5
gt; jill 5 3 5
gt; terry 4 1 4
gt;
gt; the results would be
gt;
gt; Jill
gt; Jane
gt; Terry
gt; Pete
gt; Bob
gt;
gt;
gt; Ive been given some tips of the rank function but havnt managed to work
gt; out how best to use it for my purpose.
gt;
gt;
gt; --
gt; ceemo
gt; ------------------------------------------------------------------------
gt; ceemo's Profile:
gt; www.excelforum.com/member.php...oamp;userid=10650
gt; View this thread: www.excelforum.com/showthread...hreadid=534349
gt;