+ Reply to Thread
Results 1 to 4 of 4

how to Distinct values Sort Automatically. & Separate them based on week number?

  1. #1
    Registered User
    Join Date
    10-28-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    3

    how to Distinct values Sort Automatically. & Separate them based on week number?

    I have spreadsheet with random data like this

    weekno date
    42 18 October 2015
    42 15 October 2015
    41 05 October 2015
    41 05 October 2015
    40 04 October 2015
    40 02 October 2015
    40 01 October 2015
    40 01 October 2015
    41 08 October 2015
    43 22 October 2015

    My expected result would be like this, chose distinct no, then sort & put together based on week no, leave a gap after each week no and place word TOTAL in that gap. I prefer to use a formula than macro. How to do it Please?

    weekno date
    40 01 October 2015
    40 02 October 2015
    40 04 October 2015

    Total(a gap after each week no)

    41 05 October 2015
    41 08 October 2015

    Total

    42 15 October 2015
    42 18 October 2015

    Total

    43 22 October 2015

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: how to Distinct values Sort Automatically. & Separate them based on week number?

    Use Pivot Table
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: how to Distinct values Sort Automatically. & Separate them based on week number?

    Apply sorting and use Subtotal Menu


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Registered User
    Join Date
    10-28-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    3

    Re: how to Distinct values Sort Automatically. & Separate them based on week number?

    Can this be done automatically with formula?

+ 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. Replies: 28
    Last Post: 07-17-2015, 07:32 AM
  2. Replies: 5
    Last Post: 09-01-2014, 03:55 PM
  3. [SOLVED] Find last 12 values based on week number/year
    By pytheus in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2014, 05:14 AM
  4. formula to identify week number based on date ranges and add values
    By Lmendez in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-18-2014, 12:55 PM
  5. [SOLVED] HELP! I have a list of distances and need to sort them automatically into distinct lists
    By Robot girl in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-27-2013, 12:28 AM
  6. [SOLVED] sort column based on number of duplicate values
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-03-2013, 12:35 PM
  7. [SOLVED] Calculating a Date Based on Year, Week Number and Day of the Week
    By amy in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-23-2005, 11:42 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