Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: ADVANCED LOOKUP & SORT HELP

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    [ This Message was edited by: dennisdjones on 2002-08-07 10:18 ]

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This is the table I got from your data, but
    I don't understand what exactly you are after
    You mention some colour coding is this for
    the AD_1, AD_2 etc....

    ****** bgcolor="#9F9F9F" >

    ABCDEFGHIJKLMN
    1AGENTMLSSTATUSPRICETYPEAD_1PRICE_1DATE ADVERTISEDAD_2PRICE 2DATE ADVERTISEDAD_3PRICE 3DATE ADVERTISED
    2CINDY8123Active169000L(TEXT)16900004/02/2002(TEXT)16900004/02/2002(TEXT)16900004/02/2002
    3KEN9156Active33000R(TEXT)3300004/09/2002(TEXT)3300004/09/2002(TEXT)3300004/09/2002
    4DALSE7864Active20900C(TEXT)2090004/16/2002(TEXT)2090004/16/2002(TEXT)2090004/16/2002



    _________________
    Kind Regards,
    Ivan F Moala
    http://<font color="green"><a href="...r Construction

    [ This Message was edited by: Ivan F Moala on 2002-04-15 02:15 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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