I have searched for any previous topics that may have already answered
this, but didn't find any.

I am running Excel 97. I have two spreadsheets. One is the 2006
version and the other is the 2007 version. It is a list of customers.
We want to see how many customers are on both the 2006 and the 2007
spreadsheets. The only comparison tips/programs/tools I have seen, do
just a line by line comparison. That works great if you the rows are
exactly the same, in the same order and you just want to see what data
has changed. However, my two spreadsheets may not have the same
ordering. Even when sorted, we may have added/deleted customers that
throws the order off completely from the other spreadsheet. Since a
customer may be on both spreadsheets, just not on the same row, all
the tools/tips/programs I have used so far have found every line to be
different.

What I need is something that will take the value of cell A1 from
Spreadsheet 1 and compare it against cells A1-A1000 on Spreadsheet 2,
looking for a match. Then take cell A2 from Spreadsheet 1 and compare
it against cells A1-A1000 on Spreadsheet 2, looking for a match. And
so on and so on and so on. Any help would be appreciated.

Look at a combination of IF, ISNUMBER and MATCH: =IF(ISNUMBER(MATCH([sheet1
reference,[sheet two range],0)),"match","no match")

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Jerim79" wrote:

I have searched for any previous topics that may have already answered
this, but didn't find any.

I am running Excel 97. I have two spreadsheets. One is the 2006
version and the other is the 2007 version. It is a list of customers.
We want to see how many customers are on both the 2006 and the 2007
spreadsheets. The only comparison tips/programs/tools I have seen, do
just a line by line comparison. That works great if you the rows are
exactly the same, in the same order and you just want to see what data
has changed. However, my two spreadsheets may not have the same
ordering. Even when sorted, we may have added/deleted customers that
throws the order off completely from the other spreadsheet. Since a
customer may be on both spreadsheets, just not on the same row, all
the tools/tips/programs I have used so far have found every line to be
different.

What I need is something that will take the value of cell A1 from
Spreadsheet 1 and compare it against cells A1-A1000 on Spreadsheet 2,
looking for a match. Then take cell A2 from Spreadsheet 1 and compare
it against cells A1-A1000 on Spreadsheet 2, looking for a match. And
so on and so on and so on. Any help would be appreciated.

On Mar 16, 10:43 am, Dave F wrote:
Look at a combination of IF, ISNUMBER and MATCH: =IF(ISNUMBER(MATCH([sheet1
reference,[sheet two range],0)),"match","no match")

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

"Jerim79" wrote:
I have searched for any previous topics that may have already answered
this, but didn't find any.

I am running Excel 97. I have two spreadsheets. One is the 2006
version and the other is the 2007 version. It is a list of customers.
We want to see how many customers are on both the 2006 and the 2007
spreadsheets. The only comparison tips/programs/tools I have seen, do
just a line by line comparison. That works great if you the rows are
exactly the same, in the same order and you just want to see what data
has changed. However, my two spreadsheets may not have the same
ordering. Even when sorted, we may have added/deleted customers that
throws the order off completely from the other spreadsheet. Since a
customer may be on both spreadsheets, just not on the same row, all
the tools/tips/programs I have used so far have found every line to be
different.

What I need is something that will take the value of cell A1 from
Spreadsheet 1 and compare it against cells A1-A1000 on Spreadsheet 2,
looking for a match. Then take cell A2 from Spreadsheet 1 and compare
it against cells A1-A1000 on Spreadsheet 2, looking for a match. And
so on and so on and so on. Any help would be appreciated.

I thank you for that, but this is something that needs to be done
relatively soon. I have programming skill and might be able to figure
it out by the end of the day, but I have never done VBA programming
for Excel. My boss wants it as soon as possible, and what if I can't
get it done by the end of the day. I am not reallying looking for a
programming example, I was hoping there was something I could do
within the next 10 minutes to get this accomplished. A manual
comparison is an option obviously, but is that the only option at this
point?

That's not programming. It's a standard Excel formula.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Jerim79" wrote:

On Mar 16, 10:43 am, Dave F wrote:
Look at a combination of IF, ISNUMBER and MATCH: =IF(ISNUMBER(MATCH([sheet1
reference,[sheet two range],0)),"match","no match")

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

"Jerim79" wrote:
I have searched for any previous topics that may have already answered
this, but didn't find any.

I am running Excel 97. I have two spreadsheets. One is the 2006
version and the other is the 2007 version. It is a list of customers.
We want to see how many customers are on both the 2006 and the 2007
spreadsheets. The only comparison tips/programs/tools I have seen, do
just a line by line comparison. That works great if you the rows are
exactly the same, in the same order and you just want to see what data
has changed. However, my two spreadsheets may not have the same
ordering. Even when sorted, we may have added/deleted customers that
throws the order off completely from the other spreadsheet. Since a
customer may be on both spreadsheets, just not on the same row, all
the tools/tips/programs I have used so far have found every line to be
different.

What I need is something that will take the value of cell A1 from
Spreadsheet 1 and compare it against cells A1-A1000 on Spreadsheet 2,
looking for a match. Then take cell A2 from Spreadsheet 1 and compare
it against cells A1-A1000 on Spreadsheet 2, looking for a match. And
so on and so on and so on. Any help would be appreciated.

I thank you for that, but this is something that needs to be done
relatively soon. I have programming skill and might be able to figure
it out by the end of the day, but I have never done VBA programming
for Excel. My boss wants it as soon as possible, and what if I can't
get it done by the end of the day. I am not reallying looking for a
programming example, I was hoping there was something I could do
within the next 10 minutes to get this accomplished. A manual
comparison is an option obviously, but is that the only option at this
point?

"I was hoping there was something I could do
within the next 10 minutes to get this accomplished. "

Since you put it that way...

The commercial Excel add-in "XL Companion", from yours truly,
can compare the rows in one sheet vs. the rows in another sheet.
The rows can be in any order. A list is created of all non-matches.

The same feature is available for single column lists, with a plus
that uncommon items are highlighted in yellow.

You can try it out before purchase, details at...
http://www.realezsites.com/bus/primitivesoftware
Or just send the two sheets to me and I'll make the comparsion and
send it back to you. Remove XXX from my email address.
--
Jim Cone
San Francisco, USA
XX

On Mar 16, 12:29 pm, "Jim Cone" wrote:
"I was hoping there was something I could do
within the next 10 minutes to get this accomplished. "

Since you put it that way...

The commercial Excel add-in "XL Companion", from yours truly,
can compare the rows in one sheet vs. the rows in another sheet.
The rows can be in any order. A list is created of all non-matches.

The same feature is available for single column lists, with a plus
that uncommon items are highlighted in yellow.

You can try it out before purchase, details at...http://www.realezsites.com/bus/primitivesoftware
Or just send the two sheets to me and I'll make the comparsion and
send it back to you. Remove XXX from my email address.
--
Jim Cone
San Francisco, USA


Actually, someone else pointed me in the direction of "functions." I
just do INSERT -- FUNCTION and then choose Match(). That worked
beautifully and only took a few minutes.

On Mar 16, 11:26 am, Dave F wrote:
That's not programming. It's a standard Excel formula.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

"Jerim79" wrote:
On Mar 16, 10:43 am, Dave F wrote:
Look at a combination of IF, ISNUMBER and MATCH: =IF(ISNUMBER(MATCH([sheet1
reference,[sheet two range],0)),"match","no match")

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

"Jerim79" wrote:
I have searched for any previous topics that may have already answered
this, but didn't find any.

I am running Excel 97. I have two spreadsheets. One is the 2006
version and the other is the 2007 version. It is a list of customers.
We want to see how many customers are on both the 2006 and the 2007
spreadsheets. The only comparison tips/programs/tools I have seen, do
just a line by line comparison. That works great if you the rows are
exactly the same, in the same order and you just want to see what data
has changed. However, my two spreadsheets may not have the same
ordering. Even when sorted, we may have added/deleted customers that
throws the order off completely from the other spreadsheet. Since a
customer may be on both spreadsheets, just not on the same row, all
the tools/tips/programs I have used so far have found every line to be
different.

What I need is something that will take the value of cell A1 from
Spreadsheet 1 and compare it against cells A1-A1000 on Spreadsheet 2,
looking for a match. Then take cell A2 from Spreadsheet 1 and compare
it against cells A1-A1000 on Spreadsheet 2, looking for a match. And
so on and so on and so on. Any help would be appreciated.

I thank you for that, but this is something that needs to be done
relatively soon. I have programming skill and might be able to figure
it out by the end of the day, but I have never done VBA programming
for Excel. My boss wants it as soon as possible, and what if I can't
get it done by the end of the day. I am not reallying looking for a
programming example, I was hoping there was something I could do
within the next 10 minutes to get this accomplished. A manual
comparison is an option obviously, but is that the only option at this
point?

Let me restate that. I very seldom go beyond the basics in any
spreadsheet program. I have just never had a need to learn "advanced"
formulas. I can do all the basics, but what you are describing is
something I would have to learn. I don't really have time for that. It
certainly looked like programming, with IF statements, ISNUMBER, and
MATCH. Thank you for your time.