Hello people,
I just gave up on trying to find a formula which I know must be easy.
Here is the data I have (simplified data)
(A, B, C and D are columns and the rows are A2 to A13 but my actual work would be for A2 to A1000 or better yet the whole All A column.
A...