Help needed on array formula

Why no container 3 for Ship A in your expected outcome?

On the assumption that the above was a typo, see if this gives the correct output.

Note that these are both array formulas, so must be entered and confirmed as per the instructions below, otherwise they will not work.

In G15, fill down until blank

Formula:

Please Login or Register  to view this content.

In H15, fill down until blank

Formula:

Please Login or Register  to view this content.

...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 your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

jason.b75

you are so brilliant. the formula provided are so amazing !!! it was concise and run good !!

This is very good solution (although i wasn't explain the problem in proper and clear way)..... and it really cheer my day up !!

This thread is solved, your fine solution is far more perfect and complete than this thread asked about.

Thanks again. +1

Sorry, Ali. That was my bad!

I was going to raise the point of thread title with my reply, but by the time I finished typing, the old goldfish memory syndrome came into effect.
With new members, I try to take a softer approach to rather than blocking the thread with the stock admin request canned reply.