+ Reply to Thread
Results 1 to 5 of 5

Join data unique and sum

  1. #1
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    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, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,803

    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
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    Re: Join data unique and sum

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

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    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.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  5. #5
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    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)

Similar Threads

  1. How to join two separate sheets, with identical columns, with no unique connector
    By andrew.jh.martin in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-13-2015, 08:31 AM
  2. Join rows of data
    By nredman in forum Excel General
    Replies: 3
    Last Post: 05-26-2014, 04:59 AM
  3. How to join two worksheets into one based on the data they contain
    By liaites in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-22-2013, 05:24 AM
  4. [SOLVED] SQL Join - Left Join, but with 4 tables
    By kenny.fsw in forum Access Tables & Databases
    Replies: 4
    Last Post: 05-29-2013, 09:03 AM
  5. Join data in two cells
    By nvsanilkumar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2012, 03:57 AM
  6. Compare two sets of data and join together
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2010, 10:05 AM
  7. Join data from two worksheets
    By 4joey1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2010, 03:00 PM

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