I have a sequenced list of numbers from A2:A165000. In D1 I have my target number as a column heading: 2588. In this column I would like to generate a list all of the numbers that occur directly before my target. And in E1 a list of the numbers that occur directly after my target.
I am able to find a single instance with the following formulae:
How do I expand this to find all of the other instances?