Comparing two columns

[TerryM]

I'm not an expert with Excel functions or anything and I looked up on the
internet several ways to possibly get want I want but they don't seem to
work?

I have two columns and want to know which ones are different. I don't want
to just highlight though I would like a third column filled in if the
results are different (or could be the same whatever is easier, so I could
then take that third column and use it as a checklist).

So here is the charts so far:

a e =ISNA(MATCH(A2,$B$2:$B$5,FALSE))
=IF(ISERROR(MATCH(A2,$B$2:$B$5,0)),"",A2) =OR(EXACT(B2, A2:A5))
b f =ISNA(MATCH(A3,$B$2:$B$5,FALSE))
=IF(ISERROR(MATCH(A3,$B$2:$B$5,0)),"",A3) =OR(EXACT(B3, A2:A5))
c d =ISNA(MATCH(A4,$B$2:$B$5,FALSE))
=IF(ISERROR(MATCH(A4,$B$2:$B$5,0)),"",A4) =OR(EXACT(B4, A2:A5))
d w =ISNA(MATCH(A5,$B$2:$B$5,FALSE))
=IF(ISERROR(MATCH(A5,$B$2:$B$5,0)),"",A5) =OR(EXACT(B5, A2:A5))


That didn't come out that good...

Basically I have two columns of data (a-d in one and e,f,d,w in the other).

I have then three columns of formulas I have tried.

For some reason even though I have a '=' in front of them it doesn't
actually evaluate it just shows the formula?

How do I actually get it to do something? Should be pretty simple I would
think??

Thanks,
Terry

 

[Andy B]

Have a look here:
http://www.cpearson.com/excel/duplicat.htm

If your cells are already formatted as text, a formula will remain as text.
Format the cells as general and then re-enter the formulas

 

[Peo Sjoblom]

See:

http://www.cpearson.com/excel/duplicat.htm



--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom

 

[Andy B]

Hi

Having looked at your graphic, you could just use a simple COUNTIF formula:
=COUNTIF(A$2:A$5,B2)
and fill this down.

 

[TerryM]

The cells are formatted as general and in the preview it shows up as 'TRUE'
Thanks
Terry

 

[TerryM]

Thx that looks like a good article. The problem for me right now though is
just getting the formulas I type to actually show what they are supposed to
and not just the formula. Know what I mean?

All I did was open and excel spreadsheet, and type this in??

So to do a test I just typed =5+5 <enter>
guess what the cell shows... "=5+5"

So how do I get this worksheet to actually resolve these things like it
should??

Thanks,
Terry

 

[TerryM]

The issue doesn't seem to be with the formula's for right now, just getting
the formulas to actually resolve in stead of showing up literal.

Everything I type in this worksheet is acting as if there is a ' before it.

So I type in =5+5 it is acting as if I typed '=5+5 but I'm not?

The cells are formatted as general. Where else could I look to change
things?

Terry

 

[Frank Kabel]

Hi
goto 'Tools - Options - View' and uncheck 'Formulas'

 

[TerryM]

Excellent!! Thanks, that was it. Not sure why that one worksheet would be
like that when all others were normal??
Great things are working now though.

Terry