Results 1 to 8 of 8

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

Threaded View

  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

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