santeria
Well-known Member
- Joined
- Oct 7, 2003
- Messages
- 1,844
When dealing with MAX and MIN calculations, the theoretical side of it seems straightforward, however, if you do a basic RANK formula for multiple series of numbers, is a Basic RANK formula enough? Does the use of MAX and MIN calculations from RANK figures pre-suppose that a RANK plus a COUNTIF formula is used?
Scenario at issue might be a RANK figure set that gives a result of, for example, 1,3,3,5,5 , which is the result RANK can theoretically give for a five day data-set on a Half hour range ( The double figures being figures numerically the same).
Can MAX and MIN cope with these sorts of Figures ?
Any other suggestions about trend analysis, or links gratefully received.
Ta
Scenario at issue might be a RANK figure set that gives a result of, for example, 1,3,3,5,5 , which is the result RANK can theoretically give for a five day data-set on a Half hour range ( The double figures being figures numerically the same).
Can MAX and MIN cope with these sorts of Figures ?
Any other suggestions about trend analysis, or links gratefully received.
Ta