+ Reply to Thread
Results 1 to 2 of 2

Combine data from columns with the exact same variable into a new cell

  1. #1
    Registered User
    Join Date
    09-15-2015
    Location
    San Antonio, TX
    MS-Off Ver
    13
    Posts
    3

    Combine data from columns with the exact same variable into a new cell

    Hello, I'm having a hell of a time trying to figure out how to do this and surely it is easier than I'm making it out to be, but here's my problem.

    I've got a "city" in column A while column B is the "population", however, column C has broken each city into 4 different "age groups". Now column A contains every city in the U.S. including D.C. so instead of having to combine the 4 different age groups 51 times is there a formula I can wright that passes the city name as a variable in order to combine all age groups for a "population total" for each particular "city".

    So, for example here's what I think needs to happen but how do I write this equation on a macrocosmic scale in order to make life so much easier:

    Column B1:B4(population broken down by age group) Need to be combined to make Column D[New Column](total population per city)

    Please help.

    Thanks!!!

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Combine data from columns with the exact same variable into a new cell

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Cheers!
    Deep Dave

+ 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. Replies: 8
    Last Post: 06-25-2014, 05:43 AM
  2. Combine multiple cells in columns - Concat with variable spacing using VBA Script
    By AMC_CO in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2013, 03:57 PM
  3. Combine information from multiple works sheets based on a cell and data in columns
    By Rick_HpyVly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 02:49 PM
  4. Duplicate rows, delete columns w/same data, combine columns w/unique data, Mac Excel 2011
    By msmcoin in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 02-03-2013, 02:10 PM
  5. How to match in 2 sheets with columns with non exact Text data ?
    By Faisal85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2012, 03:28 PM
  6. Replies: 4
    Last Post: 01-12-2012, 12:30 AM
  7. MATCH function - 2 columns w/ SIMILAR, not EXACT data
    By Jane in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2005, 12:06 AM

Tags for this Thread

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