Announcement

Collapse
No announcement yet.

Sort by All Colors in the column by color index

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sort by All Colors in the column by color index



    Hi,

    How to sort a column by it's TintAndShade property as 'Sort by A-Z'?

    'Sort by Color' of Auto Filter option shows each color individually.

    I want to order least value of TintAndShade to highest value.

    I have attached a sample file which have colors (And ONLY for your clearance TINTANDSHADE value (of the color in third column of same row)).
    Attached Files
    Last edited by udhaya_k; June 13th, 2018, 20:01.
    Defeat Easy, Win Hard

  • #2
    Hi,

    If I understand correctly your request ... you could use the standard sort from the Menu using :

    1. either, using Column C, Sort by ID ... Smallest to Largest

    2. or, using Column D, Sort by TintAndShade ... Smallest to Largest

    HTH
    If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

    Comment


    • #3
      Originally posted by Carim View Post
      Hi,

      If I understand correctly your request ... you could use the standard sort from the Menu using :

      1. either, using Column C, Sort by ID ... Smallest to Largest

      2. or, using Column D, Sort by TintAndShade ... Smallest to Largest

      HTH
      Hi Carim,
      Sorry about my question was not clear. I added the columns ID and TINANDSHADE only for reference. Now I've mentioned it.
      Defeat Easy, Win Hard

      Comment


      • #4
        Hi again,

        No problem ...

        You could be using a UDF such as this one :

        Code:
        Public Function TAS(c As Range)
         TAS = c.Interior.TintAndShade
        End Function
        See attached ...

        Hope this will help
        Attached Files
        If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

        Comment


        • #5
          Hi Carim,

          I am glad to have your help. But I know this formula since the color in the cells itself done by subroutine.

          I just wanted to avoid a UDF to give other non excel skilled users of my data to filter without running UDF/Subroutine. They should be able to filter data by just using the Auto filter menu only.
          Defeat Easy, Win Hard

          Comment


          • #6
            Hi,

            Sorry ... but do not fully understand your constraints ...

            Would you accept an event macro ...???
            If you feel like saying "Thank You" for the help received ...You can click on the "Like" icon ...just underneath ... ... in the bottom right corner ...

            Comment


            • #7


              Hi Carim,

              Sorry for late reply. But if it would do the trick then I would be glad.
              Defeat Easy, Win Hard

              Comment

              Working...
              X