Hi All,
I have a problem.
I have a formula that selects the lowest connection pipe possible to two pieces of equipment. I need to extend this formula so that it will pick the lowest connection that is compatible with BOTH boxes. For instance:
box one is compatible with a b and c
box two is compatible with a b and d
The lowest connection possible works out to be d, but since this is not compatible with both boxes I need to select b.
Any help much appreciated!
Alastair
Bookmarks