Results 1 to 5 of 5

Find duplicate rows based on two column values and group

Threaded View

  1. 07-29-2015, 08:01 PM #1
    kevivu
    kevivu is offline
    Registered User
    Join Date
    06-20-2015
    Location
    Chennai, India
    MS-Off Ver
    2010
    Posts
    59

    Find duplicate rows based on two column values and group

    Dear All,

    In the attached excel... i need to find the duplicate records based on COLUMN B & COLUMN E, if there are matching records, I have to sum the value present in COLUMN C for that combination and keep only one record.

    Please see the attachment for better understanding.

    Expecting an early response..

    Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Looking to separate and duplicate rows based on values in one column.
    By tdaubs in forum Excel General
    Replies: 8
    Last Post: 11-25-2014, 05:11 PM
  2. [SOLVED] Macro to find duplicate values in a column and add the corresponding rows
    By hoss88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2013, 05:40 AM
  3. Macro to Group Rows Along a Range Based on Values in a Column
    By JHCali in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-06-2013, 10:20 AM
  4. how to filter the rows based on a column which contains duplicate values...
    By Rajesh Ushakoyyala in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  5. Cut & paste rows based on duplicate column values
    By agolden7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2013, 11:09 AM
  6. Remove rows with duplicate values in one column based on value of another column
    By jolleyje in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 06:20 AM
  7. Group Rows Based on two values in a Column A
    By daillest319 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2012, 03:51 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1