Announcement

Collapse
No announcement yet.

Automatically Alphabetize

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

  • Automatically Alphabetize

    I am trying to have a list sorted alphabetically. On the attached sheet the first section of columns is what I want automatically to happen when the second set of columns are entered manually. I am using a VLOOKUP function to pull from the third (fifth column in the function). But the VLOOKUP function requires the data to be sorted otherwise the function doesn't work. So, I would prefer to not have to sort the data (if anyone knows a better way then that would be great), otherwise is there a way to automatically alphabetize the data?
    Attached Files

  • #2
    Re: Automatically Alphabetize

    I can't see any formulas in your example, but if it is to be used as a database then your design is all wrong. There should be no empty colums in a database.
    Hope that Helps

    Roy

    New users should read the Forum Rules before posting

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

    Comment


    • #3
      Re: Automatically Alphabetize

      Originally posted by royUK
      I can't see any formulas in your example, but if it is to be used as a database then your design is all wrong. There should be no empty colums in a database.
      There aren't any formulas, that is what I am asking help for, a formula to make the second set look like the first set. It is not a database (do you mean like a reference sheet or like a microsoft access database? It is for reference)

      Comment


      • #4
        Re: Automatically Alphabetize

        The Vlookup function doesn't require the list to be sorted if you use the last argument as either false or 0.

        eg vlookup(a3,lookuplist,3,0)

        Daniel

        Comment


        • #5
          Re: Automatically Alphabetize

          Originally posted by DMariotti
          The Vlookup function doesn't require the list to be sorted if you use the last argument as either false or 0.

          eg vlookup(a3,lookuplist,3,0)

          Daniel
          Awesome, it worked thanx!
          for future reference, is there a way to autmatically sort a list?

          Comment


          • #6
            Re: Automatically Alphabetize

            From the main toolbar, Data>>Sort works well

            Alastair
            Einstein:
            Things should be made as simple as possible, but not any simpler

            Be sure to check out TemplateZone for all your Microsoft Office Needs.
            Get OfficeReady Professional 3.0 here!

            Comment


            • #7
              Re: Automatically Alphabetize

              WakkoGuy,

              You can sort it alphabetically automatically by using VBA and using Excel's Worsheet_change event.

              Daniel

              Comment


              • #8
                Re: Automatically Alphabetize

                Hi

                You can also sort it dynamically using formula.

                Say you have a list of data in the range A2:A13
                In B2 enter the formula
                Code:
                =SUMPRODUCT(--($A$2:$A$13>A2))
                and copy down to B13

                In C2 enter the formula
                Code:
                =INDEX($A$2:$A$13,MATCH(LARGE($B$2:$B$13,ROW()-1),$B$2:$B$13,0))
                Copy down to C13

                Data will automatically sort.


                Tony

                Comment

                Working...
                X