Consolidate information / Summing
 

Hi all, you've been so helpful I had to throw this at you.

I have a table of data (see below).

You'll note there are multiple identical items in the 1st and 2nd
columns, the third being different

Is there an easy way to "squash" and consolidate the information,
summing the 3rd column and place it beside the corresponding items in
columns 1 and 2?


The (short version of ) the info:


016073217948 BETTY BALL EXP ENERG 11
016073217948 BETTY BALL EXP ENERG 0
016073217948 BETTY BALL EXP ENERG 2
016073217948 BETTY BALL EXP ENERG 1
016073217948 BETTY BALL EXP ENERG 23
016073217948 BETTY BALL EXP ENERG 29
018627175209 KASHI GOLEAN DRK VN4 2
018627175209 KASHI GOLEAN DRK VN4 2
000009022621 BOU OIL ROLL ON ASST 64
000009022621 BOU OIL ROLL ON ASST 29
000009022621 BOU OIL ROLL ON ASST 24
000009022621 BOU OIL ROLL ON ASST 110
000009022621 BOU OIL ROLL ON ASST 86
000009022621 BOU OIL ROLL ON ASST 13
000009022621 BOU OIL ROLL ON ASST 105
000009022621 BOU OIL ROLL ON ASST 52
000009022621 BOU OIL ROLL ON ASST 61
000009022621 BOU OIL ROLL ON ASST 2
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022638 BOU OIL MINARET ASST 11
000009022638 BOU OIL MINARET ASST 5
000009022638 BOU OIL MINARET ASST 7
000009022638 BOU OIL MINARET ASST 15
000009022638 BOU OIL MINARET ASST 21
000009022638 BOU OIL MINARET ASST 2
000009022638 BOU OIL MINARET ASST 19
000009022638 BOU OIL MINARET ASST 16
000009022645 BOU INCENSE REG ASST 12
000009022645 BOU INCENSE REG ASST 16
000009022645 BOU INCENSE REG ASST 8
000009022645 BOU INCENSE REG ASST 5
000009022645 BOU INCENSE REG ASST 31
000009022645 BOU INCENSE REG ASST 13
000009022645 BOU INCENSE REG ASST 1
000009022645 BOU INCENSE REG ASST 1
000009022652 BOU INCENSE GAR ASST 9

Consolidate information / Summing
 

Hi,

with your example data in range A1:C39 use the following formula in
column D:

=SUMPRODUCT(($A$1:$A$39&$B$1:$B$39=A1&B1)*($C$1:$C $39))

Regards,
Ingolf



Oggie Ben Doggie schrieb:

Hi all, you've been so helpful I had to throw this at you.

I have a table of data (see below).

You'll note there are multiple identical items in the 1st and 2nd
columns, the third being different

Is there an easy way to "squash" and consolidate the information,
summing the 3rd column and place it beside the corresponding items in
columns 1 and 2?


The (short version of ) the info:


016073217948 BETTY BALL EXP ENERG 11
016073217948 BETTY BALL EXP ENERG 0
016073217948 BETTY BALL EXP ENERG 2
016073217948 BETTY BALL EXP ENERG 1
016073217948 BETTY BALL EXP ENERG 23
016073217948 BETTY BALL EXP ENERG 29
018627175209 KASHI GOLEAN DRK VN4 2
018627175209 KASHI GOLEAN DRK VN4 2
000009022621 BOU OIL ROLL ON ASST 64
000009022621 BOU OIL ROLL ON ASST 29
000009022621 BOU OIL ROLL ON ASST 24
000009022621 BOU OIL ROLL ON ASST 110
000009022621 BOU OIL ROLL ON ASST 86
000009022621 BOU OIL ROLL ON ASST 13
000009022621 BOU OIL ROLL ON ASST 105
000009022621 BOU OIL ROLL ON ASST 52
000009022621 BOU OIL ROLL ON ASST 61
000009022621 BOU OIL ROLL ON ASST 2
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022638 BOU OIL MINARET ASST 11
000009022638 BOU OIL MINARET ASST 5
000009022638 BOU OIL MINARET ASST 7
000009022638 BOU OIL MINARET ASST 15
000009022638 BOU OIL MINARET ASST 21
000009022638 BOU OIL MINARET ASST 2
000009022638 BOU OIL MINARET ASST 19
000009022638 BOU OIL MINARET ASST 16
000009022645 BOU INCENSE REG ASST 12
000009022645 BOU INCENSE REG ASST 16
000009022645 BOU INCENSE REG ASST 8
000009022645 BOU INCENSE REG ASST 5
000009022645 BOU INCENSE REG ASST 31
000009022645 BOU INCENSE REG ASST 13
000009022645 BOU INCENSE REG ASST 1
000009022645 BOU INCENSE REG ASST 1
000009022652 BOU INCENSE GAR ASST 9

Consolidate information / Summing
 

That did the trick. Thanks very much!

Ingolf wrote:
Hi,

with your example data in range A1:C39 use the following formula in
column D:

=SUMPRODUCT(($A$1:$A$39&$B$1:$B$39=A1&B1)*($C$1:$C $39))

Regards,
Ingolf



Oggie Ben Doggie schrieb:

Hi all, you've been so helpful I had to throw this at you.

I have a table of data (see below).

You'll note there are multiple identical items in the 1st and 2nd
columns, the third being different

Is there an easy way to "squash" and consolidate the information,
summing the 3rd column and place it beside the corresponding items in
columns 1 and 2?


The (short version of ) the info:


016073217948 BETTY BALL EXP ENERG 11
016073217948 BETTY BALL EXP ENERG 0
016073217948 BETTY BALL EXP ENERG 2
016073217948 BETTY BALL EXP ENERG 1
016073217948 BETTY BALL EXP ENERG 23
016073217948 BETTY BALL EXP ENERG 29
018627175209 KASHI GOLEAN DRK VN4 2
018627175209 KASHI GOLEAN DRK VN4 2
000009022621 BOU OIL ROLL ON ASST 64
000009022621 BOU OIL ROLL ON ASST 29
000009022621 BOU OIL ROLL ON ASST 24
000009022621 BOU OIL ROLL ON ASST 110
000009022621 BOU OIL ROLL ON ASST 86
000009022621 BOU OIL ROLL ON ASST 13
000009022621 BOU OIL ROLL ON ASST 105
000009022621 BOU OIL ROLL ON ASST 52
000009022621 BOU OIL ROLL ON ASST 61
000009022621 BOU OIL ROLL ON ASST 2
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022621 BOU OIL ROLL ON ASST 1
000009022638 BOU OIL MINARET ASST 11
000009022638 BOU OIL MINARET ASST 5
000009022638 BOU OIL MINARET ASST 7
000009022638 BOU OIL MINARET ASST 15
000009022638 BOU OIL MINARET ASST 21
000009022638 BOU OIL MINARET ASST 2
000009022638 BOU OIL MINARET ASST 19
000009022638 BOU OIL MINARET ASST 16
000009022645 BOU INCENSE REG ASST 12
000009022645 BOU INCENSE REG ASST 16
000009022645 BOU INCENSE REG ASST 8
000009022645 BOU INCENSE REG ASST 5
000009022645 BOU INCENSE REG ASST 31
000009022645 BOU INCENSE REG ASST 13
000009022645 BOU INCENSE REG ASST 1
000009022645 BOU INCENSE REG ASST 1
000009022652 BOU INCENSE GAR ASST 9