Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a unique identifier to a column of data | Excel Worksheet Functions | |||
Selecting only rows of data with unique identifier | Excel Discussion (Misc queries) | |||
Combine data from 2 worksheets using unique identifier | Excel Worksheet Functions | |||
Unique identifier | Excel Worksheet Functions | |||
Unique identifier | Excel Programming |