| Off Topic > Off Topic |
| Excel merge entries but sum them together |
| (1/3) > >> |
| 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 |
| Navigation |
| Message Index |
| Next page |