dennisdjones
New Member
- Joined
- Apr 13, 2002
- Messages
- 19
This message was edited by dennisdjones on 2002-08-07 10:18
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ADVANCED LOOKUP & SORT HELP
- Thread starter dennisdjones
- Start date
Ivan F Moala
MrExcel MVP
- Joined
- Feb 10, 2002
- Messages
- 4,209
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....<HTML><HEAD><STYLE TYPE="text/css"></STYLE><TITLE></TITLE></HEAD><BODY bgcolor="#9F9F9F" ><FONT FACE="arial, helvetica, sans-serif"><LEFT><TABLE bgcolor="#FFFFFF" Border=2><TR><TD Align=Right bgcolor="#DFDED0">
</TD><TD Align=Center bgcolor="#DFDED0">A</TD><TD Align=Center bgcolor="#DFDED0">B</TD><TD Align=Center bgcolor="#DFDED0">C</TD><TD Align=Center bgcolor="#DFDED0">D</TD><TD Align=Center bgcolor="#DFDED0">E</TD><TD Align=Center bgcolor="#DFDED0">F</TD><TD Align=Center bgcolor="#DFDED0">G</TD><TD Align=Center bgcolor="#DFDED0">H</TD><TD Align=Center bgcolor="#DFDED0">I</TD><TD Align=Center bgcolor="#DFDED0">J</TD><TD Align=Center bgcolor="#DFDED0">K</TD><TD Align=Center bgcolor="#DFDED0">L</TD><TD Align=Center bgcolor="#DFDED0">M</TD><TD Align=Center bgcolor="#DFDED0">N</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">1</TD><TD Align=Center >AGENT</TD><TD Align=Center >MLS</TD><TD Align=Center >STATUS</TD><TD Align=Center >PRICE</TD><TD Align=Center >TYPE</TD><TD Align=Center >AD_1</TD><TD Align=Center >PRICE_1</TD><TD Align=Center >DATE ADVERTISED</TD><TD Align=Center >AD_2</TD><TD Align=Center >PRICE 2</TD><TD Align=Center >DATE ADVERTISED</TD><TD Align=Center >AD_3</TD><TD Align=Center >PRICE 3</TD><TD Align=Center >DATE ADVERTISED</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">2</TD><TD Align=Center >CINDY</TD><TD Align=Center >8123</TD><TD Align=Center >Active</TD><TD Align=Center >169000</TD><TD Align=Center >L</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >169000</TD><TD Align=Center >04/02/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >169000</TD><TD Align=Center >04/02/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >169000</TD><TD Align=Center >04/02/2002</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">3</TD><TD Align=Center >KEN</TD><TD Align=Center >9156</TD><TD Align=Center >Active</TD><TD Align=Center >33000</TD><TD Align=Center >R</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >33000</TD><TD Align=Center >04/09/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >33000</TD><TD Align=Center >04/09/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >33000</TD><TD Align=Center >04/09/2002</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">4</TD><TD Align=Center >DALSE</TD><TD Align=Center >7864</TD><TD Align=Center >Active</TD><TD Align=Center >20900</TD><TD Align=Center >C</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >20900</TD><TD Align=Center >04/16/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >20900</TD><TD Align=Center >04/16/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >20900</TD><TD Align=Center >04/16/2002</TD></TR></TABLE></LEFT></BODY><P</HTML>
_________________
Kind Regards,<font size=+2><font color="red"> I<font color="blue">van<font color="red"> F M</font color="blue">oala</font></font></font>
<font color="green">[url]http://www.gwds.co.nz/ - Under Construction[/url]
This message was edited by Ivan F Moala on 2002-04-15 02:15
I don't understand what exactly you are after
You mention some colour coding is this for
the AD_1, AD_2 etc....<HTML><HEAD><STYLE TYPE="text/css"></STYLE><TITLE></TITLE></HEAD><BODY bgcolor="#9F9F9F" ><FONT FACE="arial, helvetica, sans-serif"><LEFT><TABLE bgcolor="#FFFFFF" Border=2><TR><TD Align=Right bgcolor="#DFDED0">
</TD><TD Align=Center bgcolor="#DFDED0">A</TD><TD Align=Center bgcolor="#DFDED0">B</TD><TD Align=Center bgcolor="#DFDED0">C</TD><TD Align=Center bgcolor="#DFDED0">D</TD><TD Align=Center bgcolor="#DFDED0">E</TD><TD Align=Center bgcolor="#DFDED0">F</TD><TD Align=Center bgcolor="#DFDED0">G</TD><TD Align=Center bgcolor="#DFDED0">H</TD><TD Align=Center bgcolor="#DFDED0">I</TD><TD Align=Center bgcolor="#DFDED0">J</TD><TD Align=Center bgcolor="#DFDED0">K</TD><TD Align=Center bgcolor="#DFDED0">L</TD><TD Align=Center bgcolor="#DFDED0">M</TD><TD Align=Center bgcolor="#DFDED0">N</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">1</TD><TD Align=Center >AGENT</TD><TD Align=Center >MLS</TD><TD Align=Center >STATUS</TD><TD Align=Center >PRICE</TD><TD Align=Center >TYPE</TD><TD Align=Center >AD_1</TD><TD Align=Center >PRICE_1</TD><TD Align=Center >DATE ADVERTISED</TD><TD Align=Center >AD_2</TD><TD Align=Center >PRICE 2</TD><TD Align=Center >DATE ADVERTISED</TD><TD Align=Center >AD_3</TD><TD Align=Center >PRICE 3</TD><TD Align=Center >DATE ADVERTISED</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">2</TD><TD Align=Center >CINDY</TD><TD Align=Center >8123</TD><TD Align=Center >Active</TD><TD Align=Center >169000</TD><TD Align=Center >L</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >169000</TD><TD Align=Center >04/02/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >169000</TD><TD Align=Center >04/02/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >169000</TD><TD Align=Center >04/02/2002</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">3</TD><TD Align=Center >KEN</TD><TD Align=Center >9156</TD><TD Align=Center >Active</TD><TD Align=Center >33000</TD><TD Align=Center >R</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >33000</TD><TD Align=Center >04/09/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >33000</TD><TD Align=Center >04/09/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >33000</TD><TD Align=Center >04/09/2002</TD></TR><TR><TD Align=Right bgcolor="#DFDED0">4</TD><TD Align=Center >DALSE</TD><TD Align=Center >7864</TD><TD Align=Center >Active</TD><TD Align=Center >20900</TD><TD Align=Center >C</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >20900</TD><TD Align=Center >04/16/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >20900</TD><TD Align=Center >04/16/2002</TD><TD Align=Center >(TEXT)</TD><TD Align=Center >20900</TD><TD Align=Center >04/16/2002</TD></TR></TABLE></LEFT></BODY><P</HTML>
_________________
Kind Regards,<font size=+2><font color="red"> I<font color="blue">van<font color="red"> F M</font color="blue">oala</font></font></font>
<font color="green">[url]http://www.gwds.co.nz/ - Under Construction[/url]
This message was edited by Ivan F Moala on 2002-04-15 02:15
Upvote
0
Similar threads
- Question
