Results 1 to 2 of 2

Sort data into unique values, then find totals and count

Threaded View

  1. 07-22-2013, 12:03 PM #1
    dkang2007
    dkang2007 is offline
    Registered User
    Join Date
    06-28-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    10

    Sort data into unique values, then find totals and count

    Hi all thank you for taking a look at my problem.

    Attached, I have a sample spread sheet that includes 4 columns. Customer Name, Profit, Gallons and Codes. In the spread sheet I am working with I have around 900 customers.

    I want to see how many times a specific code such as "62" appears. I would also like to generate a unique list of codes with sum the total profit and gallons for each unique code. Any suggestions?

    If possible I would like to output the data in format found in Sheet2.
    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. Generate unique values,count of values occurences then sort
    By Hudas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2012, 05:22 PM
  2. Find and count unique values
    By famico78 in forum Excel General
    Replies: 8
    Last Post: 12-04-2009, 08:23 AM
  3. Count Unique values and summarize totals
    By MattG in forum Excel General
    Replies: 3
    Last Post: 06-26-2009, 04:59 PM
  4. Sort and Count Unique Data in 4 Columns
    By miakayuuki in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2008, 11:22 AM

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