Shortening of long array formula by short formula

[paradise2sr]

Hi,

Can formula of Column E (Reference No.) of "Result" sheet can be shorten,it's very long and difficult to understand.It is such a long that I can't paste here.
I have enclosed in attachment the file.

This I have not stated in my earlier post at http://www.excelforum.com/excel-form...aw-data-2.html

Other problems are being solved in that post only left was few.

I am learning a lot and still learning from this website and expect to learn too.

With Best Rgds,

Suresh

[Jacc]

I added a two helper columns, makes it a lot smaller. Still a complex formula though.

[paradise2sr]

Thanks for the reply.But it still a big.Slightly,it has been changed.I got solved from some other forum contributor earlier this post but due to complexity of formula,I have posted or shortening of it.Since it was a big,I did not understand that complex formula.Can you explain me your this formula breakup,sometime I might add one more thing to extract and increase my data range in that case,I must know the complete formula breakup.

Even though,I still wait that someone might make much more simplified formula and make this post unsolved till that time.

With Best Rgds