erbhaskar95
New Member
- Joined
- Apr 30, 2021
- Messages
- 14
- Office Version
- 2016
- Platform
- Windows
Hello there,
I need some help getting information from my data.
Lets say I have a number range in excel that I want to check what range it falls under and indicate it with some value or number or text.
Starting Ending
21.28 39.62
39.78 64.93
122.14 142.28
142.69 167.81
1580 1610
3249 3300
I want to check if my starting and ending points fall in the below category and indicate which range it falls to with (numbers, text etc) or anything that I can use later.
For example,
39.78 to 64.93 falls in S.N (1) Range and so the formula should indicate it by telling us that it falls in that category 1.
122.14 to 142.28 also falls in S.N (1) Range but max value is limited to 152.62 only
1580 to 1610 does not fall in any range and so the formula should return a false value or no value
S.N Range (Starting) Range (Ending)
1 0 152.62
2 396.27 610.16
3 680.52 804.28
4 888.22 1039.66
5 1524.08 1617.37
6 2037.18 2240.69
7 2692.1 2954
8 3232.55 3432.83
9 3780.27 3974.62
Please help!
I need some help getting information from my data.
Lets say I have a number range in excel that I want to check what range it falls under and indicate it with some value or number or text.
Starting Ending
21.28 39.62
39.78 64.93
122.14 142.28
142.69 167.81
1580 1610
3249 3300
I want to check if my starting and ending points fall in the below category and indicate which range it falls to with (numbers, text etc) or anything that I can use later.
For example,
39.78 to 64.93 falls in S.N (1) Range and so the formula should indicate it by telling us that it falls in that category 1.
122.14 to 142.28 also falls in S.N (1) Range but max value is limited to 152.62 only
1580 to 1610 does not fall in any range and so the formula should return a false value or no value
S.N Range (Starting) Range (Ending)
1 0 152.62
2 396.27 610.16
3 680.52 804.28
4 888.22 1039.66
5 1524.08 1617.37
6 2037.18 2240.69
7 2692.1 2954
8 3232.55 3432.83
9 3780.27 3974.62
Please help!