comparing data without unique identifier
 

I am attempting to compare 2 worksheets (one from another agency) and there
is no unique identifier. Each has a specific grant number; one may be OH
W-13-L-1, the other W13L1. In addition, the vendor name, although similar,
is not usually exactly the same. such as Hunter, J vs. Hunter Estate.

I receive the other agency's worksheet via excel and download mine from
Access.

I could use either program to compare, if I knew what to do! Any suggestions?

Thanks!

comparing data without unique identifier
 

Linda
You posted a similar question on 18 May to which you received a couple
responses. Did those responses help or maybe give you a way to go? Otto
"Linda" wrote in message
...
I am attempting to compare 2 worksheets (one from another agency) and there
is no unique identifier. Each has a specific grant number; one may be OH
W-13-L-1, the other W13L1. In addition, the vendor name, although
similar,
is not usually exactly the same. such as Hunter, J vs. Hunter Estate.

I receive the other agency's worksheet via excel and download mine from
Access.

I could use either program to compare, if I knew what to do! Any
suggestions?

Thanks!

comparing data without unique identifier
 

Otto, I was never able to retrieve the messages. When I went to the link
provided in the email, I just got a blank page. I tried looking it up via
key words, but nothing appeared. :-(

"Otto Moehrbach" wrote:

Linda
You posted a similar question on 18 May to which you received a couple
responses. Did those responses help or maybe give you a way to go? Otto
"Linda" wrote in message
...
I am attempting to compare 2 worksheets (one from another agency) and there
is no unique identifier. Each has a specific grant number; one may be OH
W-13-L-1, the other W13L1. In addition, the vendor name, although
similar,
is not usually exactly the same. such as Hunter, J vs. Hunter Estate.

I receive the other agency's worksheet via excel and download mine from
Access.

I could use either program to compare, if I knew what to do! Any
suggestions?

Thanks!