Hi Domenic,

Thank you very much once again. Formula does the job Brilliantly!

Before Posting I tried to adapt one of your earlier Formulas and spent ages
trying to get it to work; reading through your Post I now realise the very
reason my adaptation did not work: I forgot to change the Sheet Reference!

Domenic wrote:
*Change the sheet reference accordingly.

Cheers,
Sam

Domenic wrote:
Assuming that there will 'always' be only one occurrence of the criteria
for each row, try...

E9, copied across and down:

=IF(E$2<"",LARGE(IF(Results=E$2,ROW(Results)-MIN(ROW(Results))+1),ROWS(E
$9:E9))-LARGE(IF(Results=E$2,ROW(Results)-MIN(ROW(Results))+1),ROWS(E$9:E
9)+1)-1,"")

...confirmed with CONTROL+SHIFT+ENTER. If there can be more than one
occurrence of the criteria for a row, try the following instead...

1) Select/highlight E9

2) Insert Name Define

Name: MMULT3

Refers to:

=MMULT(--(Results=Sheet1!E$2),TRANSPOSE(COLUMN(Results)^0))

*Change the sheet reference accordingly.

Click Ok

3) E9, copied across and down:

=IF(E$2<"",LARGE(IF(MMULT3,ROW(Results)-MIN(ROW(Results))+1),ROWS(E$9:E9
))-LARGE(IF(MMULT3,ROW(Results)-MIN(ROW(Results))+1),ROWS(E$9:E9)+1)-1,""
)

...confirmed with CONTROL+SHIFT+ENTER.

4) Use conditional formatting to hide error values.

Hope this helps!

Hi All,

[quoted text clipped - 46 lines]
Thanks
Sam


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200510/1