Results 1 to 4 of 4

Thread: IIF (2000)

  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IIF (2000)

    I have a Column that has a value of Acceleration, Evaluation, Initial Review, Developing or Pass. I would like to be able to sort in this order, not alphabetically. I figured the best way is to add a column and indicate the sort order. Acceleration =1, Evaluation = 2, Initial Review = 3, Developing = 4, Pass = 5. Is an IIf statement best, if so, what would logic be, Or should this be some kind of lookup?

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: IIF (2000)

    There are several approaches, one is to put your list in order as a Table, shown here in Column D, and use =MATCH(,,), like this to get your number to sort on:
    <table border=1><td></td><td align=center>A</td><td align=center>B</td><td align=center>C</td><td align=center>D</td><tr><td align=center>1</td><td>Evaluation</td><td align=right>=MATCH(A1,$D$1:$D$5,0)</td><td align=right>
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: IIF (2000)

    You can create a custom list and use it as the sorting order.

    To create the list goto Tools, Options, and select the Custom Lists tab.

    There should be an entry for NEW LIST in the 'List' of lists. Click on this and in the List Entries box enter your iterms in the required order, Click on Add and close. See attached screen capture.

    To use the custom list whilst sorting, select Options in the sort dialog, and then from the First key sort order dropdown select your list.

    Andrew C

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IIF (2000)

    "You can create a custom list and use it as the sorting order."

    <font color=red> [b] You can create a you can create imported custom lists and use it as the sorting order.
    1. Select the range where you have your new list (ordered in the order that your you want)
    2. To create the list goto Tools, Options, and select the Custom Lists tab. Click on

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •