+ Reply to Thread
Results 1 to 5 of 5

Join data unique and sum

  1. #1
    Registered User
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    google excel
    Posts
    60

    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.

    https://docs.google.com/spreadsheets...it?usp=sharing

    Thanks Ditch

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2016
    Posts
    11,401

    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. #3
    Registered User
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    google excel
    Posts
    60

    Re: Join data unique and sum

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

  4. #4
    Valued Forum Contributor xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    2,088

    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.
    D.

  5. #5
    Registered User
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    google excel
    Posts
    60

    Re: Join data unique and sum

    That will do the trick thank you very much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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