if/true/false help
 

I know this is probably simple, but i just can't get it to work :o

I have a column of numbers in a worksheet. I get updated data feeds that
may have changes in the numbers. I copy this column next to the existing
column.

I need a formula that will tell me if each row in the column matches the row
in the next column.

so E2 is true if it matches F2, E3 to F3, E4 to F4, etc
and false if it does not match.
--
Thanks :) Lori

if/true/false help
 

Paste this formula in G2
=IF(AND(E2="",F2=""),"",E2=F2)

Copy the G2 formula and paste it to the remaining cells of G Column.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Lori" wrote:

I know this is probably simple, but i just can't get it to work :o

I have a column of numbers in a worksheet. I get updated data feeds that
may have changes in the numbers. I copy this column next to the existing
column.

I need a formula that will tell me if each row in the column matches the row
in the next column.

so E2 is true if it matches F2, E3 to F3, E4 to F4, etc
and false if it does not match.
--
Thanks :) Lori

if/true/false help
 

Thank you thank you thank you! I was driving myself crazy already :)
--
Thanks :) Lori


"Ms-Exl-Learner" wrote:

Paste this formula in G2
=IF(AND(E2="",F2=""),"",E2=F2)

Copy the G2 formula and paste it to the remaining cells of G Column.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Lori" wrote:

I know this is probably simple, but i just can't get it to work :o

I have a column of numbers in a worksheet. I get updated data feeds that
may have changes in the numbers. I copy this column next to the existing
column.

I need a formula that will tell me if each row in the column matches the row
in the next column.

so E2 is true if it matches F2, E3 to F3, E4 to F4, etc
and false if it does not match.
--
Thanks :) Lori

if/true/false help
 

You are welcome and thanks for feeding back.

--------------------
(Ms-Exl-Learner)
--------------------


"Lori" wrote:

Thank you thank you thank you! I was driving myself crazy already :)
--
Thanks :) Lori


"Ms-Exl-Learner" wrote:

Paste this formula in G2
=IF(AND(E2="",F2=""),"",E2=F2)

Copy the G2 formula and paste it to the remaining cells of G Column.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Lori" wrote:

I know this is probably simple, but i just can't get it to work :o

I have a column of numbers in a worksheet. I get updated data feeds that
may have changes in the numbers. I copy this column next to the existing
column.

I need a formula that will tell me if each row in the column matches the row
in the next column.

so E2 is true if it matches F2, E3 to F3, E4 to F4, etc
and false if it does not match.
--
Thanks :) Lori