Perhaps Macro Help? Automatic Fill In Function?

Put the codes that you want to use for each category against each type, i.e. starting in G6:

A
AP
B
CC
PC
G
HH

Then you can use this formula in B2:

=IF(A2="","",VLOOKUP(A2,$F$6:$G$12,2,0)&COUNTIF(A$2:A2,A2))

Copy this down as far as you need to.

Hope this helps.

Pete

I updated the spreadsheet attachment to reflect the changes you suggested and simplified it as well, please take a look.


I tried playing around with it and couldn't quite understand. What would go into B8 & B9 for example so that it could be auto generated to read "GE1" & "GE2"?



Thank you for your patience.

Originally Posted by Pete_UK

Put the codes that you want to use for each category against each type, i.e. starting in G6:

A
AP
B
CC
PC
G
HH

Then you can use this formula in B2:

=IF(A2="","",VLOOKUP(A2,$F$6:$G$12,2,0)&COUNTIF(A$2:A2,A2))

Copy this down as far as you need to.

Hope this helps.

Pete

I updated the spreadsheet attachment to reflect the changes you suggested and simplified it as well, please take a look.


I tried playing around with it and couldn't quite understand. What would go into B8 & B9 for example so that it could be auto generated to read "GE1" & "GE2"?



Thank you for your patience.

You copy the formula that I gave you above into cell B2, and then just copy it down as far as you need it (even beyond the data that you have currently, so that it will give you the next values when you add new data).

Hope this helps.

Pete

Originally Posted by Pete_UK

You copy the formula that I gave you above into cell B2, and then just copy it down as far as you need it (even beyond the data that you have currently, so that it will give you the next values when you add new data).

Hope this helps.

Pete

Yes, It functioned properly! Thank you so much. I love you! If you want to send me your cashapp, venmo, zelle, or paypal I'll send you a tip to buy your next beer, I insist! I truly appreciate the help!


Thanks again!

Eric

All help on the forum is offered for FREE - we just like to share our knowledge around !!

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete