Results 1 to 2 of 2

Calculate the total of a unique item and place in column G and make remaining items 0

Threaded View

djfscouse Calculate the total of a... 11-05-2015, 03:17 PM
djfscouse Re: Calculate the total of a... 11-05-2015, 03:18 PM
  1. 11-05-2015, 03:17 PM #1
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    323

    Calculate the total of a unique item and place in column G and make remaining items 0

    Hi,

    I have to calculate the total of a unique item listed in column E and display its total in column G for the first unique item and then make the remaining unique items with a 0 in column G

    I have attached an example showing the data before runnning VBA and after VBA is applied.

    Excel 2003 is being used.

    Thanks for any help,

    David
    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. [SOLVED] Count Unique Items in a Column Based on Unique Items in Two Other Columns
    By HangMan in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-31-2015, 04:48 PM
  2. [SOLVED] Count the number of Unique Items in a Column for each Unique Item in another Column
    By HangMan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-27-2015, 01:18 PM
  3. [SOLVED] Formula to calculate remaining vacation days from total
    By Tricia0923 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2015, 10:17 PM
  4. Find the lowest scoring item in a group of items and place it on another sheet
    By caliskier in forum Excel General
    Replies: 9
    Last Post: 11-24-2013, 08:30 AM
  5. How to auto determine MAX and MIN for each item from total items ?
    By slackerzkiddo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2013, 11:34 AM
  6. Remove specific item from array while preserving order of remaining items
    By g8r777 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2012, 01:57 AM
  7. Extract unique items from a Table and place in a column
    By Evilshrew in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-28-2007, 02:36 AM

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