Calculating the intersection of 2 lines 2

G'day again excel forum

I've been having a large problem with this over the past few months and have been out bush a lot without access to reliable internet, not aiding matters.

Basically I have a series of rows within which is described 2 intersecting lines and need to find a way of automating the calculation of the coordinates of the intersection (X and Y). Automating this is absolutely essential as many combinations of vectors will need to considered, I understand the algebra of calculating the intersection but I can't work out how to get it to work in excel (see attached example).

I've post about this before and a very helpful bloke gave me a solution however I couldn't for the life of me understand it, nor could I modify it to compute it all on a single row (in a database of 2 vector combinations) this post can be found here: http://www.excelforum.com/excel-form...ml#post3522230

I am really up the creek on this one, so if there’s anyone out there with any ideas (either original or a way to get the other method to work for me), please let us know.