Hello!!
I wonder if there is an easy formula based way to count intersections between 20 lines on a chart.
There are in theory 400 possible intersections. I am sure this can be done with a macro but I wonder if there can be an elegantly crafted formula solution to this question. I have attached the workbook with the lines (http://ifile.it/f9j1o0i).
Thanks a lot for your time!)
Dima
I wonder if there is an easy formula based way to count intersections between 20 lines on a chart.
There are in theory 400 possible intersections. I am sure this can be done with a macro but I wonder if there can be an elegantly crafted formula solution to this question. I have attached the workbook with the lines (http://ifile.it/f9j1o0i).
Thanks a lot for your time!)
Dima
