View Single Post
  #1   Report Post  
JJ Joobler
 
Posts: n/a
Default Excel Adding duplicated numbers together

I am importing a .txt file from a portable data collector to Excel. I can't
figure out how to get the program to recognize duplicated numbers in order to
add them together. The .txt file reads like this:
33110003,2

The ',2' is the count from the .txt file but does not add other numbers
together that are the same. So when I read the file on excel it looks like
this:
33110003,2
33110003,4

I want it to be this way:
33110003,6

Please help, thank you!