Insert value in one column based on info in another column

[sedanstr]

Hi

I need help with a formula.

I have two colums with data (C and D). I want data to be written in E based on the data in D:
Find first 5 A. Write A1.
Find next 8 A. Write A2
Find next 8 A. Write A3
Find next 5 A. Write A4
Find next 8 A. Write A5

Se attached file what I mean.

[PaulM100]

Something like this:

Please Login or Register  to view this content.

[samba_ravi]

e4=IF(D4="A",IFERROR("A"&LOOKUP(COUNTIF(D$4:D4,D4),{1,6,14,22,27,35},{1,2,3,4,5}),""),"")
Try this and copy towards down

[Special-K]

in E4
=IF(D4="A",LOOKUP(COUNTIF(D$4:D4,"A"),{0,6,14,22,27,35},{"A1","A2","A3","A4","A5"}),"")
and copy down the column

[sedanstr]

Thanks a lot! All of them worked!

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.