A
Axim5
Hi,
I am new to this forum, infact this is my first thread. I have been
reading various threads and replies and I must say that I am impress
with the level of knowledge available here.
Now, I would like assistance in figuring out a solution.
I have 2 sheets with following data (for example):
Sheet 1:
Cert # Amount
CA 1000345 $1,000.00
and the above continue on to upto 600 rows.
On Sheet 2: I also have the same data (not necessarily the same
numbers).
I want to do the following:
I would like to (on a new sheet) list of all the duplicate "Cert #s"
and their corresponding "Amounts".
What is the easiest way to do that?
BTW, I am using Excel 2002.
Thanaks is advance.
I am new to this forum, infact this is my first thread. I have been
reading various threads and replies and I must say that I am impress
with the level of knowledge available here.
Now, I would like assistance in figuring out a solution.
I have 2 sheets with following data (for example):
Sheet 1:
Cert # Amount
CA 1000345 $1,000.00
and the above continue on to upto 600 rows.
On Sheet 2: I also have the same data (not necessarily the same
numbers).
I want to do the following:
I would like to (on a new sheet) list of all the duplicate "Cert #s"
and their corresponding "Amounts".
What is the easiest way to do that?
BTW, I am using Excel 2002.
Thanaks is advance.