Hi Bob,

No problem.

Cheers,
Sam

Bob Phillips wrote:
Sorry Sam,

I completely misundersttod what you wanted.

My formula could be adapted to work, but as you have a good solution from
Domenic, it is hardly worth it.

Hi Bob,

[quoted text clipped - 3 lines]

Use this array formula

=IF(ISERROR(SMALL(IF((ISNUMBER(MATCH(D3:Z3,$D$6:$ Z$6,0)))+(ISNUMBER(MATCH(D3

:Z3,$D$16:$Z$16,0))),COLUMN($D$3:$Z$3)-MIN(COLUMN($D$3:$Z$3))+1,""),TRANSPOS
E(ROW($A1:$A20)))),"",

INDEX(D3:Z3,1,SMALL(IF((ISNUMBER(MATCH(D3:Z3,$D$6 :$Z$6,0)))+(ISNUMBER(MATCH(

D3:Z3,$D$16:$Z$16,0))),COLUMN($D$3:$Z$3)-MIN(COLUMN($D$3:$Z$3))+1,""),TRANSP
OSE(ROW($A1:$A20)))))

Cheers,
Sam

--
Message posted via http://www.officekb.com