Setting the range of numbers, and performing subtraction

[ayhp91]

Hello,
I am creating a range of numbers from 1 to 2000 with increments of 0.5. Then I have to subtract certain range, for example, 100 to 350. So, the result should display, 1 to 95.5 and 350.5 to 2000. How can I do that?
Thank you

[hemesh]

Assuming your Numbers is in A1 to A4000
in D2 type 100 as your start number E2 type 500 as your end number
in F2 Copy paste below then Hold control and shift together and then Hit enter and then drag down the formula till you get blanks
=IFERROR(INDEX($A$1:$A$4000,SMALL(IF(NOT(($A$1:$A$4000>=$D$2)*($A$1:$A$4000<=$E$2)),ROW($A$1:$A$4000)),ROW(A1))),"")

[ChemistB]

How are you creating these numbers; is it in a single column, single row, multiple columns and rows? How are you envisioning this deletion taking place? Do they simply clear the cells? delete and remove blanks so that other values move up?

[ayhp91]

The structure of the data is that as follows:
Let's say the database is for highway mileage maintenance. So the mileage are set as from 1 to 2000 with 0.5 increments. So 1 will be in one cell and 2000 will be in another cell. Everyday, the maintenance team will cover certain amount of mileage. So, for the first day, if the team covers from 100 to 350, the result should be 1 to 95.5 and 350.5 to 2000. Sorry for the first post. I think it doesn't express well.
Thank you

[hemesh]

Like this ?

Formula entered here are array formulas! You need to confirm them by holding control and shift together and then hitting enter key instead of just enter.