+ Reply to Thread
Results 1 to 1 of 1

Aggregate values in columns based on a cell identifier

  1. 08-30-2015, 03:33 AM #1
    bjarmeister
    bjarmeister is offline
    Registered User
    Join Date
    08-25-2015
    Location
    Copenhagen
    MS-Off Ver
    2010
    Posts
    1

    Aggregate values in columns based on a cell identifier

    Hello Everyone.
    I have a very large CSV file that I'm using for a statistical analysis.
    ap1agtt.png Screenshot of data is attached

    In column K and L are some values that are unique for each row. I would like to create a new column that aggregates the values of K and L individually if they share the same value found in column B. Does anyone know how to do this?
    Best regards

    EDIT: Figured it out with a Pivot Table
    Last edited by bjarmeister; 08-30-2015 at 04:10 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. PIVOT: how to show text values in columns (identical per identifier)
    By sb_zh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-07-2014, 03:37 AM
  2. [SOLVED] Sum selected values in matrix based on date range as well as unique identifier in row
    By smansyd in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-09-2014, 07:56 PM
  3. Button to pull data from another area based on active cell as identifier
    By gotjobs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2014, 02:49 AM
  4. Aggregate multiple values into one cell based on multiple criteria using VBA
    By jwestover1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-04-2013, 01:17 PM
  5. Locking columns based on calculated cell values in columns across a sheet.
    By andyr826208 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2012, 05:17 AM
  6. Combine rows of data into 1 cell based on unique identifier
    By jud_goh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-11-2010, 05:06 PM
  7. Formula to return a unique identifier to a row of data based on 2 columns?
    By krups in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-07-2009, 07:02 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1