Need Filter Formulas for the attached excel sheet

[Techtrend]

Hi Team

Need Filter Formulas to match the nearest Strike prices and get prices above and below that Strike prices

Have Briefed in detail in the attached document.

Thanks for your time
Narendra Kumar

 

[Nebu]

Hi:

May be this? I have to use a helper column to achieve this.

Thanks

 

[Techtrend]

HI

Awsome,Thanks for the efforts,
It works fine

Regards
Narendra Kumar