wrote
Max, it's incredibly kind of you to do all this work and put together
the example spreadsheet but I'm embarrassed to say
that I cannot figure it out.

Are the two different tabs supposed to work in tandem?

Yes, of course.

X is presumed to be where the source table lies,
and Y is another sheet to extract/display the final results neatly

How exactly do I apply these formulas to my spreadsheet.
I know I'm a lost cause
but I didn't think this kind of sorting would be so complicated

Could you upload a small sample of your actual** file
and paste the *link* to it in your reply here ?
**sanitized if necessary

I'll take a look at your sample, apply whatever's possible <g
and then post a reply/link to it back here.

Use either of these 2 free n easy-to-use filehosts
to upload your sample:

http://www.flypicture.com/
http://cjoint.com/index.php

For cjoint.com (it's in French), just click "Browse" button,
navigate to your folder select the sample file Open,
then click the button centred in the page below
(labelled "Creer le lien Cjoint") and it'll generate the
link. Then just copy & paste the generated link as part
and parcel of your response here.

But kindly note that no attachments
should be posted *directly* to the newsgroup
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---