Splitting of the data range based on upper and lower limit criteria

[vemulasandeep]

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

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.