software

I have the following

name Meals days work-sales
bob....1............1.............3
pete...3.............1............3
jane...2..............2...........5
jill......5.............3.............5
terry..4 ..............1............4

I would like to add a new column that gives a priority column on the
end of the table. The highest priority will be number one and will goto
the person with the highest number of work-sales then days then highest
meals.

The table would look like

name Meals.....days.....work-sales...Priority
bob....1............1.............3...........5
pete...3.............1............3...........4
jane...2..............2...........5............2
jill......5.............3.............5........... 1
terry..4 ..............1............4..........3I would like to do this using a formula rather than a script--
ceemo
------------------------------------------------------------------------
ceemo's Profile: www.excelforum.com/member.php...oamp;userid=10650
View this thread: www.excelforum.com/showthread...hreadid=534708Assuming worksales in D15, days in C1:C5, meals in B1:B5, you could
use the following:

=SUMPRODUCT(--(100*$D$1:$D$5 10*$C$1:$C$5 $B$1:$B$3gt;100*D1 10*C1 B1)) 1

Does this help?

Kostis VezeridesCeemo

this works on your sample data, though it needs an intermediate column. I'm
not sure if it could be combined ... but I couldn't work it out.

in Column E, cell E2, put the fomula:

=RANK(B2,B:B,1) RANK(C2,C:C,1) RANK(D2,D,1)

in column F, cell F2, put the formula:

=RANK(E2,E:E,0)

Column F is the Priority that you wanted.

Drag both formulae down. This gave the right result for your data though I
don't know if it will give you what you want on a grander scale. But, give
it a go

Regards

Trevorquot;ceemoquot; gt; wrote in
message ...
gt;
gt; I have the following
gt;
gt; name Meals 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; I would like to add a new column that gives a priority column on the
gt; end of the table. The highest priority will be number one and will goto
gt; the person with the highest number of work-sales then days then highest
gt; meals.
gt;
gt; The table would look like
gt;
gt; name Meals.....days.....work-sales...Priority
gt; bob....1............1.............3...........5
gt; pete...3.............1............3...........4
gt; jane...2..............2...........5............2
gt; jill......5.............3.............5........... 1
gt; terry..4 ..............1............4..........3
gt;
gt;
gt; I would like to do this using a formula rather than a script
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=534708
gt;
OK ... that's the way to do it in one go !

I needed to tweak it a little ... think there's a typo ($B$3) and also
assumed the first row was a header.

Regards

Trevorquot;vezeridquot; gt; wrote in message oups.com...
gt; Assuming worksales in D15, days in C1:C5, meals in B1:B5, you could
gt; use the following:
gt;
gt; =SUMPRODUCT(--(100*$D$1:$D$5 10*$C$1:$C$5 $B$1:$B$3gt;100*D1 10*C1 B1)) 1
gt;
gt; Does this help?
gt;
gt; Kostis Vezerides
gt;