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!
|