Hi,
Greetings of the Day…!
Can anyone help me solving this issue.
I am working on a large data sheet with too many values from the data file and specified criteria to extract the desired output. The following table describes the issue.
Criteria: total length of difference from 150m to 450m is 300m which has to be divided and split in to multiple columns based on the range of lower and upper limit values
Lower limit Range Upper limit Range Result
0 200 50
200 400 200
400 600 50
600 800
800 1000
1000 1200
1200 1400
1400 1600
1600 1800
1800 2000
Please help me out in obtaining the desired result. Please do needful. PFA sample example sheet explaining the problem statement.
Thanks in Advance
Regards
Sandeep
Bookmarks