Using excel to write wiring connection plan

Originally Posted by Glenn Kennedy

Brr. That took a while. Try this. there are a lot of complex array formulae here. BUT, so far as I can see it reproduces your example. here's hoping that it was representative of the real thing.

Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

I also had to create a helper column on the first sheet to get it to work. it can be hidden, of course.

O my, I'm grateful to you so much! have been struggling for days with array formulas.

I'm new to "advanced" excel and have been able to pull out data from this kind of table that you have now created.
This is only part of project but it means a lot to me, thank you.

Have tried to input some extra data and works just fine.

Only one thing I need to correct, In column D and H on sheet3. Terminals a shown only if they are number, it can happend that for some kind of apparatus terminal is combination of letter and number, example: "A1" or "Y+".
I guess all I need to do is to make same rule under column D and H as it is on C and G to do that.

Thank you again, will analyze those formulas as much as I can and try to learn from it.
You helped me a lot. Wish I could sent you a beer

All best,
Caplja