EXCEL - How To calc on blocks of rows separated by blank row ?
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.
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.