+ Reply to Thread
Results 1 to 6 of 6

Make an Unique List and Total

  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Make an Unique List and Total

    I want to make a unique list from data table and get totals from table.

    Attached file, you can see detail explanation and what is wanted exactly.

    Thanks in advance for any reply and help.

    Regards,
    turist
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: Make an Unique List and Total

    Looking for any reply
    Last edited by turist; 11-26-2013 at 01:18 PM.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,101

    Re: Make an Unique List and Total

    not sure i fully understand

    do you want the machines listed out uniquely

    so for your example

    3
    5
    6
    7
    8
    13
    22

    and totals for each machine

    or do you just want the dates unique
    so

    1/11/13
    4/11/13

    and totals for those

    can you provide expected results - maybe on the spreadsheet and on the forum - so we understand what the final output and values are
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: Make an Unique List and Total

    Again , added file and solved Production Total by formula.
    Only I need make Unique Machine No. List depending in same day.

    Please see attached file.

    Thanks a lot.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: Make an Unique List and Total

    Waiting for any help.

  6. #6
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: Make an Unique List and Total

    I can solve the issue by myself.

    You can see attached file, if any member want to use .
    Attached Files Attached Files

+ 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. Make Unique Name List and Sum Data
    By turist in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-04-2013, 03:46 PM
  2. Replies: 1
    Last Post: 04-19-2013, 02:25 AM
  3. [SOLVED] Make a Unique List from data table
    By turist in forum Excel General
    Replies: 4
    Last Post: 03-02-2013, 06:08 PM
  4. [SOLVED] Make unique list from a cells in one row
    By biber in forum Excel General
    Replies: 6
    Last Post: 04-07-2012, 03:43 PM
  5. Make list of unique values
    By Roeltje in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-12-2011, 09:03 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1