I have a set of numbers in a column M4:M36. The smallest number is 0 and the larget is in the hundreds of million. I would like to create another column to return a value from 0 to 10 where the biggest number in column M would return 10 and the smallest 0.

I have tried this, but not much luck. Returns 10 everywhere.... any advice you can give me would be extremely appreciated!

**=INT(CEILING(M4,MAX($M$4:$M$36)/10)*10/MAX($M$4:$M$36))**

Thank you,

Gowardo