# Join data unique and sum

1. ## Join data unique and sum

Hi im just wondering if anyone can help, i have data in cell A and B and D and E, i want to move the data from D and E and add it to the Bottom of A and B, but the data will very from day to day on how much or little there is, so it would need to find the next blank cell and add from there, once data is together i think want it to unique and sum up total's plz help, the data does not have to move from D and E to A and B just need to get unique from all the data and sum it up, so if there is a simpler way to do it i dont mind what way its done. thanks for any help, here is a example.

Thanks Ditch

2. ## Re: Join data unique and sum

Try this:

``Please Login or Register  to view this content.``
How to install your new code
1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:
1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

3. ## Re: Join data unique and sum

Hi thanks for the reply, probs would have help if I said I use google sheets.

4. ## Re: Join data unique and sum

Hi,

If there is a reasonable maximum number of rows, you might use a couple of UNIQUE formulas to build up the list
=UNIQUE(A1:A100) in G2
and then
=UNIQUE(D2:D100) in G102
and then use
=UNIQUE(FILTER(G2:G201,ARRAYFORMULA(G2:G201<>"")))
to get the final unique list.

5. ## Re: Join data unique and sum

That will do the trick thank you very much.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1