I am trying to Build a relationship between two different columns. The data
comes from two different spreadsheets(SS). I copy and paste them into a
third sheet then compare like data. The data from SS1 is in columns A, B, C,
D and the data from SS2 is in columns E thru H. How can I format the Countif
function to reference data location A1 and E1? I have tried
Countif(A1:E1,A1) but that compares all columns A thru E and says true if any
of those fields match. I have done the work around and put like data next to
each other but if I did not need to do that that would be easier. Any help
would be appreciated.

am not really sure what you want.
Do you want to know if A1 and E1 are identical?
Try =A1=E1 for a true or false answer
Do you want to know if A1 is duplicated somewhere in E1:H??.
(more complicated)


"Bud Hughes" wrote:

I am trying to Build a relationship between two different columns. The data
comes from two different spreadsheets(SS). I copy and paste them into a
third sheet then compare like data. The data from SS1 is in columns A, B, C,
D and the data from SS2 is in columns E thru H. How can I format the Countif
function to reference data location A1 and E1? I have tried
Countif(A1:E1,A1) but that compares all columns A thru E and says true if any
of those fields match. I have done the work around and put like data next to
each other but if I did not need to do that that would be easier. Any help
would be appreciated.

What I am trying to do is in Column A compare the data to column E while
remaining in the same row, then using conditional formatting highlight the
rows in column A that match column E

"bj" wrote:

am not really sure what you want.
Do you want to know if A1 and E1 are identical?
Try =A1=E1 for a true or false answer
Do you want to know if A1 is duplicated somewhere in E1:H??.
(more complicated)


"Bud Hughes" wrote:

I am trying to Build a relationship between two different columns. The data
comes from two different spreadsheets(SS). I copy and paste them into a
third sheet then compare like data. The data from SS1 is in columns A, B, C,
D and the data from SS2 is in columns E thru H. How can I format the Countif
function to reference data location A1 and E1? I have tried
Countif(A1:E1,A1) but that compares all columns A thru E and says true if any
of those fields match. I have done the work around and put like data next to
each other but if I did not need to do that that would be easier. Any help
would be appreciated.

Disregard I figured it out. Rather than use a formula for conditional
formatting I used the cell is option. Thanks for the input

"bj" wrote:

am not really sure what you want.
Do you want to know if A1 and E1 are identical?
Try =A1=E1 for a true or false answer
Do you want to know if A1 is duplicated somewhere in E1:H??.
(more complicated)


"Bud Hughes" wrote:

I am trying to Build a relationship between two different columns. The data
comes from two different spreadsheets(SS). I copy and paste them into a
third sheet then compare like data. The data from SS1 is in columns A, B, C,
D and the data from SS2 is in columns E thru H. How can I format the Countif
function to reference data location A1 and E1? I have tried
Countif(A1:E1,A1) but that compares all columns A thru E and says true if any
of those fields match. I have done the work around and put like data next to
each other but if I did not need to do that that would be easier. Any help
would be appreciated.