Off Topic > Off Topic
Excel merge entries but sum them together
Darryl McKoy:
--- Quote from: Waru on November 05, 2017, 01:03:53 AM ---well what's the code i would need
--- End quote ---
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:
--- Quote from: Waru on November 05, 2017, 01:03:53 AM ---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
--- End quote ---
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:
--- Quote from: SWAT One on November 06, 2017, 02:28:06 PM ---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.
--- End quote ---
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:
--- Quote from: Darryl McKoy on November 06, 2017, 02:31:34 PM ---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
--- End quote ---
Sorry, the problem wasn't exactly clear to me.