Comparing two lists
Jim,
Sorry I wasn't clear.
We are comparing that the Items in D are the same ones as in A.
What I am doing is copying into columns new prices. Providing the tickers
in D match those in A, I will then copy the new prices in E over the old ones
in B.
Thanks, Alan
--
achidsey
"Jim Thomlinson" wrote:
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
|