On Wed, 29 Jun 2005 10:23:55 +0100, "Bob Phillips" <[email protected]>
wrote:
>Michael,
>
>I read this that you want to include anything starting with P1 in the P1
>numbers, so a slight change to Ron's suggestion
>
>=SUM(IF(FREQUENCY(IF((A1:A10<>"")*(LEFT(B1:B10,2)="P1"),MATCH(A1:A10,A1:A10,
>0)),ROW(INDIRECT("1:"&ROWS(A1:A10))))>0,1))
>
>still an array formula.
I read it that way at first; then when I went back and looked at his attempt,
with the P1-C40???, I thought my initial interpretation was incorrect.
Now he has several options.
--ron
Bookmarks