Off Topic > Off Topic
Excel merge entries but sum them together
Waru:
Hello tech support blockland forums I am having a problem with Excel
I am categorizing all my pokerman cards and recording them except I dont want these gay ass duplicates when i mass enter them in, case in point:
I have 2 Jangmo-o's that are completely the same, I want them to automatically go into the first entry (line 23) when entered and change it so the 1 is a two, obviously. Is there any way I can feasibly do this?
Foxscotch:
can you be more specific about what you're tryna do so we know this aint one of those XY problems
Darryl McKoy:
I don't think you can without VBA.
An alternative would be to have one sheet with your raw list, and another sheet where you have a pivot table that shows a unique list and a count of the number of duplicates
Ipquarx:
You can sort by name and do it manually pretty easily, unless you have multiple tens of thousands of cards.
Waru:
--- Quote from: Darryl McKoy on November 05, 2017, 12:59:42 AM ---I don't think you can without VBA.
--- End quote ---
well what's the code i would need
--- Quote from: Ipquarx on November 05, 2017, 01:07:26 AM ---You can sort by name and do it manually pretty easily, unless you have multiple tens of thousands of cards.
--- End quote ---
I probably have >700 cards, already tedious enough entering them in.
--- Quote from: Foxscotch on November 05, 2017, 12:56:04 AM ---can you be more specific about what you're tryna do so we know this aint one of those XY problems
--- End quote ---
These are the same card. I have two. There are two entries. Each entry says I have 1 (the one on the right). Add them together and I have two. I basically want a way to automatically make instead of the two entries it's just