Function help

  • Thread starter Thread starter Derrell Roberts
  • Start date Start date
D

Derrell Roberts

I am wanting to know how to get excel to look at a coloumn of information
and compare with another coloumn and then tell me what and where the
differences are. Let me explain what I have. I have a spreadsheet that has
two seperate "pieces" of information. Each piece has two coloumns. What I
need to do is have a function that will look at coloumn a and then compare
it with coloumn b. The twist in this is that the information does not line
up as far as the rows go. I am running Excel 2000 on an XP box. Any help
is great. thanks!!!!

Derrell
 
Try using conditional formatting.

Select all cells in column 1, and in CF, use a formula of

=ISNUMBER(MATCH(A1,$B$1:$B$1000),0)

and click format and select a colour from the pattern tab.

Repeat, with appropriate adjustment for the other column .

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top