Is there a way

[dwt]

I am importing acsii data in the format detailed below and need to compare
the addresses to find the ones that don't match. If they don't match I want
to keep that record and delete the records that match. Is this something that
can be done with a Macro?
Any help or suggestions would be greatly appreciated...

thanks

david

a b c d
|--------------------------------------------------
1 | 1223 main st | 1223 | main | st |
|--------------------------------------------------
2 |1111 broad st | 6789 | broadway | st |
| --------------------------------------------------

 

[Mark]

Hi,
you will need a macro to sort he matches. send me the
ascii file and i will create a min-program to do the work
for you.
See my stuff at:
http://www.geocities.com/excelmarksway
http://au.geocities.com/excelmarksway

- -mark
(e-mail address removed)

 

[dwt]

Mark,

I've sent them.. thanks for you help..

d

Hi,
you will need a macro to sort he matches. send me the
ascii file and i will create a min-program to do the work
for you.
See my stuff at:
http://www.geocities.com/excelmarksway
http://au.geocities.com/excelmarksway

- -mark
(e-mail address removed)