B
Bud Hughes
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.
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.