data ranking

[Alex Kachanov]

Still can't find solution to my problem: I need ranking combined with
grouping. E.g. I have column of data ranging 0..100. I need to divide this
data to 10 levels 1..10 in such way:

0..9.99 will be level 1
10..19 will be 2,
etc. ending with level 10 - 90..99,9.

I want universal solution so I can only enter number of levels in formula.

Help me pls to do this.

Thanks ;-)

________________
Alexander Kachanov aka Alex29
ICQ# 14840340

 

[Bernie Deitrick]

Alex,

=INT(A1/10)+1

More generally,

=INT(A1/NumOfLevels)+1

HTH,
Bernie
MS Excel MVP

 

[Bernie Deitrick]

Alex,

The general case is actually:

=INT(A1/NumsPerLevel)+1

or

=INT(A1/(Span/NumOfLevels))+1

which in your case is:
=INT(A1/(100/NumOfLevels))+1
=INT(A1/(100/10))+1
=INT(A1/10)+1

Sorry about that.

HTH,
Bernie
MS Excel MVP