Quote:
Originally Posted by Spencer101
It's possible to get Excel to "Rank" numbers uniquely, so two numbers the same will rank differently. This may be what you need to do.
Simple to do if you're able to use a "helper column".
Might be possible to combine into one formula but would need to see an example workbook (with no confidential information) to be certain of that.
If you're able to post one, either I or one of the other clever people on here will be happy to help.
S.
|
cheers spencer. I only have Open office on the home comp and don't think I can upload from this work comp. Nothing confidential in the files just some team stats and plenty of pretty charts .
I am happy to use a helper column if you can explain how to uniquely rank them.
I'll have to upload them from home but should be able to save as xls format. I'm using version 2003 in work by the way
cheers,
Dj