Creating a number range between two values

[Anonymous]

how to create a range of values from a column

Example

numerical values

10

20

25

30

35

40

45

need ranges from 10 - 30 = 1

range from 31 to 40 = 2

range from 41 to 45 = 3

greater than 45  = 4

[parry2k · Accepted solution]

@Anonymous add new column and use swtich function

Range = 
SWITCH( TRUE(),
Table[Number Value] > 45, 4,
Table[Number Value] > 40, 3,
Table[Number Value] > 30, 2,
Table[Number Value] > 9, 1
)