thanks to you all for the response. I did use domenic's "frequency" in the
end

Regards

Domenic wrote:
Assuming that A2:B9 contains the data, let D2 and D3 contain GA1234 and
GA234, then try the following...

E2, copied down:

=SUMPRODUCT(--(A$2:A$9=D2),--(B$2:B$9<""),--(MATCH(A$2:A$9&B$2:B$9,A$2:A
$9&B$2:B$9,0)=ROW(B$2:B$9)-ROW(B$2)+1))

or

=COUNT(1/FREQUENCY(IF(A$2:A$9=D2,IF(B$2:B$9<"",MATCH(B$2:B $9,B$2:B$9,0))
),ROW(B$2:B$9)-ROW(B$2)+1))

Note that the latter formula needs to be confirmed with
CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

Hi

[quoted text clipped - 25 lines]

Brian

--
bnt

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200605/1