software

I am currently using the rank function and when a tie occurs they have
the same rank.

So assume I have three months of sales that are the same... their
ranking looks like this 1,1,1

I want it to rank the first occurence and then add 1 to each following
rank that is the same so in this example it would return....1,2,3

I hope this is possible.

Thanks--
Skeep
------------------------------------------------------------------------
Skeep's Profile: www.excelforum.com/member.php...oamp;userid=30822
View this thread: www.excelforum.com/showthread...hreadid=505216Look at unique rank

www.cpearson.com/excel/rank.htm

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Skeepquot; gt; wrote in
message ...
gt;
gt; I am currently using the rank function and when a tie occurs they have
gt; the same rank.
gt;
gt; So assume I have three months of sales that are the same... their
gt; ranking looks like this 1,1,1
gt;
gt; I want it to rank the first occurence and then add 1 to each following
gt; rank that is the same so in this example it would return....1,2,3
gt;
gt; I hope this is possible.
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Skeep
gt; ------------------------------------------------------------------------
gt; Skeep's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30822
gt; View this thread: www.excelforum.com/showthread...hreadid=505216
gt;
Awsome, it worked. Thanks.--
Skeep
------------------------------------------------------------------------
Skeep's Profile: www.excelforum.com/member.php...oamp;userid=30822
View this thread: www.excelforum.com/showthread...hreadid=505216