I get

Quote:

A1 A2 P1 P2 A1 P1

using

Quote:

=E2&SUMPRODUCT(--($A$2:A2=A2)*($E$2:E2=E2)*($F$2:F2=F2))

HTH

VBA Noob

__________________
_________________________________________


Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters

Please remember to wrap code.

Forum Rules

Please add to your signature if you found this link helpful. Excel links !!!