To compare info from two worksheets

  • Thread starter Thread starter lisaoc
  • Start date Start date
L

lisaoc

I need to compare once column of data in first worksheet to
two columns in second worksheet.
What is the best way of doing this??

thank
 
What kind of comparisons are you making? What are you looking for -
duplicates? differences? less than/greater than? in either one of the two
columns? only in both columns? What are you comparing - text? dates?
numbers? More info = more help. 8>)

Ed
 
No matter what comparison you're making, maybe it would be helpful for you
to know that it is possible to write formulas that access data on different
worksheets. If you're familiar with using =A1 to access the data in cell A1
on the current worksheet, then all you need to know to work with data on
other worksheets is that the syntax is =Sheet2!A1
 
Back
Top