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?

[Ad Bot]

[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]

I don't think you can without VBA.

well what's the code i would need

You can sort by name and do it manually pretty easily, unless you have multiple tens of thousands of cards.

I probably have >700 cards, already tedious enough entering them in.

can you be more specific about what you're tryna do so we know this aint one of those XY problems

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

[Darryl McKoy]

well what's the code i would need

A pivot table would be easier and serve the same purpose

If you're not sure how to do it, upload the file and post it and I'll make one for you

[Foxscotch]

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

is it enough for one to say 0 and the other to say 2? that would be easy with formulas. a pivot table like bolt said would also be easy
I think as a general rule, if you have to use VBA to do something, excel might just not be the right tool

[SWAT One]

Maybe look into the COUNTA, COUNTIF, or COUNTIFS functions?

Google Sheets also has a COUNTUNIQUE function which Excel does not have, if that's of any help.

[Darryl McKoy]

Maybe look into the COUNTA, COUNTIF, or COUNTIFS functions?

Google Sheets also has a COUNTUNIQUE function which Excel does not have, if that's of any help.

If he does it like that he'll still have two entries rather than a single entry with a count of two, unless he makes a new list with duplicates removed and then counts the raw data list - which would be better done by a pivot table

[SWAT One]

If he does it like that he'll still have two entries rather than a single entry with a count of two, unless he makes a new list with duplicates removed and then counts the raw data list - which would be better done by a pivot table

Sorry, the problem wasn't exactly clear to me.

[RedGajin]

could also be done p easily via powershell command but im sure thats more complicated then just sorting by unique values and counting duplicates in excel locally