Hello,
I have a list of Items with codes.
NAME CODE Product A ABC Product B ABC
I would like to add X (probably 5) different suffixes to the code. For example, I would to add to ABC-01, ABC-02 and so on until ABC-05.
NAME CODE Product A ABC-01 Product B ABC-02
All the codes will have the some suffix added to them.
Doing this manually will take me a full day (100s of products)
Any ideas?
Thank you
Are there any rules that define which suffix is added? Can this be linked to either the name or the code? If not, then I think that you'll have todothis at least partially manually...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Try this one
=B1&"-"&TEXT(ROWS(B$1:B1),"00")
Row\Col Product A ABC ABC-01 Product B ABC ABC-02
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
It is confusing that you say you will add probably 5 different suffixes and then say that all the codes will have the same suffix. Can you upload an example of maybe 30 lines showing what you have now and what you would expect to have. (and why if it's not clear). Go Advanced>Manage Attachments.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Here is the sheet and explanation:It is confusing that you say you will add probably 5 different suffixes and then say that all the codes will have the same suffix. Can you upload an example of maybe 30 lines showing what you have now and what you would expect to have. (and why if it's not clear). Go Advanced>Manage Attachments.
sheet.xlsx
in F4 and copy down
=B4&"-"&TEXT(COUNTIF(E$4:E4,E4),"00")
Thank you.
Furthermore:
If I have a list a products like seen, how to I duplicate each product 5 times?
So instead of having:
Product 1 Product 2 Product 3
I'll have:
Product 1 Product 1 Product 1 Product 1 Product 1 Product 2 Product 2 Product 2 Product 2 Product 2 Product 3 Product 3 Product 3 Product 3 Product 3
And then I could apply the formula you suggested above.
Thank you
If Product1 let's say, listed 5 times the formula will do 01,02,03,04,05 if listed 3 times then 01,02,03
I understand,
But, as you can see in the sheet, all the products are listed just once, but I need to duplicate each 4 more times to create total of 5 instances of each, because I want 5 different suffixes. How can I also duplicate quickly without having to copy and paste each one?
Again, I have a list of 500(+-) products from product 1 to product 500. Each appears just once. I need to duplicate each one to a total of 5, and add 5 different suffices to each.
I hope Im making myself clear
also, the product have actual names and not numbers like so:
LEMON BOTTLE BLUE SHIRT CELL PHONE
Not really sure what you need at this point. Do you simply want to repeat the number of times product name?
Select the entire range (AA4:B23) and copy and paste it below itself, repeat 3 more times. Then if you want, you can sort by column A to bring all of Product 1 together.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks