+ Reply to Thread
Results 1 to 2 of 2

Sort data into unique values, then find totals and count

  1. #1
    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

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Sort data into unique values, then find totals and count

    Hi dkang,

    This is a perfect reason for learning Pivot Tables. With your data it took about 20 seconds to get your answer. See the attached with an answer. You should explore Pivot Tables and see what else you can do with your real data.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1