B
bxc2739
Hi,
I am trying to match/cross reference (check by ZIP CODE) two extremel
large databases/spreadsheets in MS EXCEL. The vast majority of matche
will turn up negative (no match) and only like <5% of all th
rows/fields in my 31000+ excel sheet will actually match by zip to th
records contained in another sheet (actually this second sheet is
large Seibel Sales database that I exported to Excel for easie
access/manipulation) So it would be very tedious and a time waster t
manually match the records by hand. My question would be, is there a
automated way in Excel (or using any number of Excel addons such a
ASAP Utilities etc) that would let the computer do the work for me??
Basically I have two large records, one that I exported from Siebe
online to Excel, and the second one is the original work Excel databas
that I am to work on (ie find matches by zip code and mark them a
matched)
Is there a quick way to do this? The power of the computer shoul
really be put to use, but I just don't know /cant figure out how to g
about this.
Any ideas would be helpful, thanks!
BTW here is the screenshots and explainations if you don't know what
am talking about:
http://www.freewebs.com/bxc2739/
-B
I am trying to match/cross reference (check by ZIP CODE) two extremel
large databases/spreadsheets in MS EXCEL. The vast majority of matche
will turn up negative (no match) and only like <5% of all th
rows/fields in my 31000+ excel sheet will actually match by zip to th
records contained in another sheet (actually this second sheet is
large Seibel Sales database that I exported to Excel for easie
access/manipulation) So it would be very tedious and a time waster t
manually match the records by hand. My question would be, is there a
automated way in Excel (or using any number of Excel addons such a
ASAP Utilities etc) that would let the computer do the work for me??
Basically I have two large records, one that I exported from Siebe
online to Excel, and the second one is the original work Excel databas
that I am to work on (ie find matches by zip code and mark them a
matched)
Is there a quick way to do this? The power of the computer shoul
really be put to use, but I just don't know /cant figure out how to g
about this.
Any ideas would be helpful, thanks!
BTW here is the screenshots and explainations if you don't know what
am talking about:
http://www.freewebs.com/bxc2739/
-B