Well I'm lost... What are we comparing. Are we confirming that all of the
itmes in A also exist in D, or are we comparing the price for an item in A
with the price of the corresponding Item in D or ???
--
HTH...

Jim Thomlinson


"achidsey" wrote:


Excel Experts,

What code will compare two lists?

More specifically, my spreadsheet is similar to the following:

A B C D E
1
2 CurSym Price DataSym DataPrice
3 AMD 22 ADM 23
4 HWP 30 HWP 31
5 INTC 21 INTC 22
6 MSFT 27 MSFT 28

If I name Cells A3..A6 with variable CurSyms, and name D3..D6 with variable
DataSyms, how do I ask in my code,

If CurSyms = DataSyms Then ?

Do I compare them cell by cell using a loop, or can I compare the whole list
at once?

Thanks in advance,
Alan







--
achidsey