Filling the numbers between two cells

[Gandalf_NotGrey]

Hello 

I have a set of data (excel attached) in which there is a field F1 having either a number (which is equal to the Record ID field) or it is Null ().

My requirement is to pull all the records between these two fields. 

So, for example, as per the attached excel, Cell B33 is 32 and cell B60 is 59 and I want all the rows from 32 to 59, exact condition being [Record ID] >= 32 and [Record ID] < 59.

How can I do this?

Thanks so much for your kind support.

[binuacs · Accepted solution]

@Gandalf_NotGrey one way of doing this

[Gandalf_NotGrey]

Thanks so much @binuacs - This worked like a charm.