I have a dataset with 8 columns and anywhere between 10 and 20 rows depending on the day. Column E is sorted smallest to largest, with all values beginning with either a 4 or 9. I need to insert a line between the last value beginning with a 4 and the first value beginning with 9.
I also need to have a formula in E2 (E1 is a header) populate in column E from E2 until the above mentioned line.