Mar 28 2004, 01:14 AM
As amounts are entered in column B I am wondering if Excel would we able to automatically assign a ranking number in column C beginning with the lowest figure being assigned a "1" and the next highest figure a "2" etc.
Mar 28 2004, 03:48 AM
You can use the Rank() function that comes with Excel (I am using XP BTW)
Mar 28 2004, 09:07 AM
This is absolutely what I was looking for.
Many thanks Charles,
Mar 28 2004, 11:27 AM
glad I could help.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here