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