More INDIRECT questions

[gfoulks]

So I have this function that is working wonderfully

Please Login or Register  to view this content.

But now I need to change the worksheets so that the "Detail" worksheets are named "Raw Data"

And

Where I was looking for 2118 in column C I now need to find 2118 in a string of data in Column A that looks like this (always in the 3rd position)

20050401;18463213;2118;X;X;X;0


How should I modify my function?

Thanks,
Greg

[Domenic]

Try...

=SUMPRODUCT(COUNTIF(INDIRECT("'04"&TEXT(ROW(INDIRECT("1:30")),"00")&" Raw Data'!A:A"),"*2118*"))

Hope this helps!

[gfoulks]

That did it!

Thanks,
Greg