At the moment I have a range of values ranging from 0 - 10,000 and what I'm trying to do is to sort these values in 500 increments so that i can then count the amount of times values fall under each respective banner and build a frequency distribution.
Random Values for Example:
1245
2144
567
267
3000
2567
And how i wan them sorted is :
< 500 = 1
500-1000 = 1
1000-1500 = 1
1500-2000 = 0
2000-2500= 0
2500-3000 = 2
The values I have are sourcing from a .csv file
The row name i am trying to sort is called DAYS, I have tried the following expression but it does not give me what i want