EXCEL - How To calc on blocks of rows separated by blank row ?

Job ID: 34189964

Budget: £20 – £250 GBP

1) Would like to use a formula, not VBA.
2) Columns BO and BP (Min & Max) to be populated by a formula.
3) Formula needs to not be adversely affected by occasional spurious characters in column BN (eg BN19)
4) Completion of project is a formula I can paste in BO2 and BP2 respectively, fill down 200,000 rows, and it recreates what I currently have (manually) in columns BO and BP.
Related categories: Visual Basic Data Processing Excel