+ Reply to Thread
Results 1 to 8 of 8

Compare Rows, Delete duplicate values, Sum values but Retain blank rows

  1. #1
    Registered User
    Join Date
    12-01-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    18

    Compare Rows, Delete duplicate values, Sum values but Retain blank rows

    Excel 2003
    Raw data is given from Column A to D (Table 1). There is a need to process these raw data so that the processed data is displayed from Colum G to J (Table 2).
    The processing logic is as such: For rows that have the same "Time", "Price" AND "Type" columns, adds the "Volume" values and display all information at the first row. Do NOT delete any rows.

    RAW Data (Table 1) PROCESSED Data (Table 2)
    A B C D G H I J
    Time Price Volume Type Time Price Volume Type
    8:58:19 2.77 2,000 Buy Up 8:58:19 2.77 4,000 Buy Up
    8:58:19 2.77 2,000 Buy Up
    9:00:00 2.76 10,000 Sell Down 9:00:00 2.76 10,000 Sell Down
    9:00:02 2.76 5,000 Sell Down 9:00:02 2.76 15,000 Sell Down
    9:00:02 2.76 5,000 Sell Down
    9:00:02 2.76 5,000 Sell Down
    9:01:11 2.75 7,800 Sell Down 9:01:11 2.75 7,800 Sell Down
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Compare Rows, Delete duplicate values, Sum values but Retain blank rows

    Try the attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-01-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: Compare Rows, Delete duplicate values, Sum values but Retain blank rows

    Thanks, jindon.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Compare Rows, Delete duplicate values, Sum values but Retain blank rows

    If the problem is solved, please mark the thread as "Solved".

  5. #5
    Registered User
    Join Date
    12-01-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: Compare Rows, Delete duplicate values, Sum values but Retain blank rows

    Yes, the problem is solved.

  6. #6
    Registered User
    Join Date
    12-01-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: Compare Rows, Delete duplicate values, Sum values but Retain blank rows

    I've gotten a new request to produce Table 3 with non-zero entries being moved up. No deletion of rows is allowed.

    Attached excel worksheet for clarification.

    Can you help?
    Attached Files Attached Files

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Compare Rows, Delete duplicate values, Sum values but Retain blank rows

    Quote Originally Posted by chancw View Post
    Yes, the problem is solved.
    Why didn't you mark the thread title?
    Attached Files Attached Files
    Last edited by jindon; 11-24-2013 at 07:41 AM.

  8. #8
    Registered User
    Join Date
    12-01-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: Compare Rows, Delete duplicate values, Sum values but Retain blank rows

    Thanks, I just marked the thread as solved.

+ 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. VBA helps needed to Sum duplicate values and delete duplicate rows
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2013, 11:40 PM
  2. Replies: 5
    Last Post: 11-12-2012, 08:38 PM
  3. Delete rows with duplicate values
    By Smohrman in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 02-02-2011, 10:17 PM
  4. Want to compare values out of different workbooks and delete rows.
    By DebruyneN in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2010, 06:06 AM
  5. Delete duplicate rows and retain only one
    By canada123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-04-2010, 07:40 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