M
Martin
A newbie needs help in Excel 2000
I have 4 spreadsheets from 4 different sources that I need
to compare against each other. I don't mind doing this
piecemeal if I have too (2 lists at a time). I can sort
the lists on a common unique field (Social Security
Number), but I need to come up with one list that will
somehow show the deltas.
1) The first problem I have is that before I can compare
them, some of the fields need to be converted. For example:
One list shows - Technical Specialist-Installation &
Maintenance
The other list shows - TECH SPEC-INSTALL & MAINT
I can make a master list of the differences, but I need a
way to do a search and replace on multiple columns as well.
What I need is a global search and replace based on a set
of entries (kind of like the AutoCorrect feature).
2) I thought that after the data was converted, I could
add a worksheet with the following formula:
=EXACT(Master!B2,Master!B3), etc
and just find the False values to examine. Unless somebody
has a better idea.
Thanks in advance
I have 4 spreadsheets from 4 different sources that I need
to compare against each other. I don't mind doing this
piecemeal if I have too (2 lists at a time). I can sort
the lists on a common unique field (Social Security
Number), but I need to come up with one list that will
somehow show the deltas.
1) The first problem I have is that before I can compare
them, some of the fields need to be converted. For example:
One list shows - Technical Specialist-Installation &
Maintenance
The other list shows - TECH SPEC-INSTALL & MAINT
I can make a master list of the differences, but I need a
way to do a search and replace on multiple columns as well.
What I need is a global search and replace based on a set
of entries (kind of like the AutoCorrect feature).
2) I thought that after the data was converted, I could
add a worksheet with the following formula:
=EXACT(Master!B2,Master!B3), etc
and just find the False values to examine. Unless somebody
has a better idea.
Thanks in advance