is there a way to use the rank function over a sum of two cells (well,
columns) without creating a third column with the sum in it?

so, if i have column a and column b both filled with numbers, i want to
assign a rank based on a + b without doing something like rank(c1,c:c)
where c is a + b.


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=535591