vbanoob2011
New Member
- Joined
- Jun 5, 2011
- Messages
- 8
I'm using the formula =RANK(Number, Ref, Order) but excel does not seem to be able to distinguish between really small numbers. For example, 5.0x10^10 & 8.1x10^10 (5.0E10 & 8.1E10) are both given the same ranking.
I have tried both General, and Number format styles, and tried making sure all the values had the same, high number of decimal places, but it makes no difference.
Please help, thanks!
I have tried both General, and Number format styles, and tried making sure all the values had the same, high number of decimal places, but it makes no difference.
Please help, thanks!