Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: Automatically Alphabetize

  1. #1
    Join Date
    22nd July 2004
    Posts
    29

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,302

    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

    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.

  3. #3
    Join Date
    22nd July 2004
    Posts
    29

    Re: Automatically Alphabetize

    Quote 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)

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th October 2003
    Location
    Perth, Western Australia
    Posts
    103

    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

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    22nd July 2004
    Posts
    29

    Re: Automatically Alphabetize

    Quote 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?

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    5th May 2005
    Location
    University of Kent!!, UK
    Posts
    988

    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!

  7. #7
    Join Date
    26th October 2003
    Location
    Perth, Western Australia
    Posts
    103

    Re: Automatically Alphabetize

    WakkoGuy,

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

    Daniel

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    6th May 2005
    Posts
    1,036

    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
    VB:
    =SUMPRODUCT(--($A$2:$A$13>A2)) 
    
    
    and copy down to B13

    In C2 enter the formula
    VB:
    =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

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 8
    Last Post: December 5th, 2007, 16:51
  2. Automatically Going To Next Tab Index
    By m4r1u5 in forum EXCEL HELP
    Replies: 4
    Last Post: June 28th, 2007, 23:35
  3. Copy Data To Sheet1 And Alphabetize
    By brook1 in forum EXCEL HELP
    Replies: 1
    Last Post: September 28th, 2006, 09:23
  4. Alphabetize Coloums
    By carreannjoe in forum EXCEL HELP
    Replies: 2
    Last Post: December 23rd, 2005, 22:53
  5. alphabetize index
    By patb53 in forum EXCEL HELP
    Replies: 8
    Last Post: March 13th, 2005, 11:19

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
  •  
porno