Consolidate data

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3137164%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EConsolidate%20data%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3137164%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20trying%20to%20sum%20figures%20in%20column%20J%20for%20each%20member%20listed%20in%20column%20A.%20For%20example%2C%20add%20up%20all%20the%20balances%20for%20Joe%20Blogs%20and%20have%20them%20displayed%20in%20just%20one%20row%20with%20%C2%A3211.84%20rather%20than%20the%20three%20rows%20with%20different%20balances%20already%20displayed.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EDo%20I%20use%20the%20consolidation%20tool%20to%20do%20this%3F%20So%20far%20I've%20been%20able%20to%20do%20this%20but%20wherever%20I%20reference%20for%20the%20consolidated%20table%20to%20go%2C%20it%20does%20not%20display%20all%20the%20other%20information%20such%20as%20email%20addresses.%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thanks%2C%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EBeck%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3137164%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3137164%22%20slang%3D%22en-US%22%3EConsolidate%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3137164%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20trying%20to%20sum%20figures%20in%20column%20J%20for%20each%20member%20listed%20in%20column%20A.%20For%20example%2C%20add%20up%20all%20the%20balances%20for%20Joe%20Blogs%20and%20have%20them%20displayed%20in%20just%20one%20row%20with%20%C2%A3211.84%20rather%20than%20the%20three%20rows%20with%20different%20balances%20already%20displayed.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EDo%20I%20use%20the%20consolidation%20tool%20to%20do%20this%3F%20So%20far%20I've%20been%20able%20to%20do%20this%20but%20wherever%20I%20reference%20for%20the%20consolidated%20table%20to%20go%2C%20it%20does%20not%20display%20all%20the%20other%20information%20such%20as%20email%20addresses.%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thanks%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBeck%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3137164%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello,

I am trying to sum figures in column J for each member listed in column A. For example, add up all the balances for Joe Blogs and have them displayed in just one row with £211.84 rather than the three rows with different balances already displayed. 


Do I use the consolidation tool to do this? So far I've been able to do this but wherever I reference for the consolidated table to go, it does not display all the other information such as email addresses.

Many thanks, 

 

Beck 

1 Reply

@beckgolubows 

Here's a quick approach... it's not the most elegant proposal solution, but it's a proposal solution :))

 

The proposal solution is in the attached file.

 

Hope I was able to help you with this proposal.

 

NikolinoDE

I know I don't know anything (Socrates)