How do I solve this puzzle? If the value in A2=A3 and the value in B2 <> B3 I wish to have the value "Conflict" in both C2 and C3
Thanks!
How do I solve this puzzle? If the value in A2=A3 and the value in B2 <> B3 I wish to have the value "Conflict" in both C2 and C3
Thanks!
Last edited by ConneXionLost; 10-21-2011 at 01:13 AM. Reason: Marked as SOLVED
How about:
Same formula in both C2 and C3.Please Login or Register to view this content.
Cheers,
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
Thanks... That worked. I was not detailed enough in my example however... The worksheet could have many rows of data that I need to compare to determine "conflicts" between the data rows. I need a formula that I can expand across all populated rows in the worksheet. The data will have mostly unique values but will duplicate in column A and be unique in column B sporadically throughout the sheet.
post an example showing what you mean
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you for the response... We figured out the formula. =IF(OR((AND(A2=A3,B2<>B3)),(AND(A2=A1,B2<>B1))),"Conflict","").
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks