Closed Thread
Results 1 to 2 of 2

Slicer Numerical Months Sorter

  1. #1
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,054

    Question Slicer Numerical Months Sorter

    Hi Group

    I'm using Slicer to filter months and want to have Numerical Months order - Not Alphabetical order

    My dates range between 2022 to 2024

    I think in my example, I need to change function in Column F to look up table in Column C to get desired result.

    Uncertain how to change.

    See example
    Attached Files Attached Files
    MyCon
    -- Using Latest Version of Excel

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Slicer Numerical Months Sorter

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #2 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...ate-range.html

    Thread closed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Slicer months in correct order
    By Morte1974 in forum Excel General
    Replies: 4
    Last Post: 12-31-2020, 12:32 AM
  2. Replies: 1
    Last Post: 05-22-2017, 03:19 AM
  3. Please help: Slicer Issues - not displaying all months to select
    By pigment01 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-19-2017, 04:09 PM
  4. timeline slicer for months only
    By zico8 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 10-26-2016, 03:30 AM
  5. [SOLVED] Pivot chart won't change when I add months using the slicer
    By Mrs.H in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-02-2015, 04:59 PM
  6. Timeline Slicer showing more months than in data set
    By berkeleyjake in forum Excel General
    Replies: 3
    Last Post: 04-03-2015, 08:12 AM
  7. Slicer Months shows <, > values as well.
    By OldMan62 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-20-2014, 07:17 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