Is there a way to compare one column with another?

[Guest]

How can I compare numbers in one column to make sure that the numbers in
another column are the same for each row?

 

[MartinW]

Hi Tammy,

Say your data is in columns A and E,
Input a helper column F
In F1 put =IF(A1=E1,"","Error")
Click on the fill handle and drag down as far as is needed.
It will return an Error when they aren't equal otherwise a blank.

You could also do it with conditional formatting.
Select all of your data in column E making sure E1 is the active cell
Go to Data>Conditional Formatting
And set Formula is =A1<>E1
Click on format button and set a color for the cell
from the patterns tab and OK out.

HTH
Martin

 

[MartinW]

Wooops

Go to Data>Conditional Formatting

That should read
Go to Format>Conditional Formatting

Big night! <g>

 

[Guest]

Thanks for your help, works Great!

Tammy

Hi Tammy,

Say your data is in columns A and E,
Input a helper column F
In F1 put =IF(A1=E1,"","Error")
Click on the fill handle and drag down as far as is needed.
It will return an Error when they aren't equal otherwise a blank.

You could also do it with conditional formatting.
Select all of your data in column E making sure E1 is the active cell
Go to Data>Conditional Formatting
And set Formula is =A1<>E1
Click on format button and set a color for the cell
from the patterns tab and OK out.

HTH
Martin

 

[MartinW]

You're welcome Tammy.

Thanks for your help, works Great!

Tammy