I have had endless problems with Excel crashing or taking an age to calculate. I have just discovered that
it is due to curly bracketed array formulas. My worksheets often contain in excess of 140,000 rows.
Could someone please help me substitute the below formula to one without brackets even if a helper column is required.