Excel 2007: Three comparisons

[Tony O]

I am working on a spreadsheet that tracks salespeople.
I want to show when a salesperson move merchandise to another
salesperson.

Column A has the salesperson code
Column B has the transaction code.

When a salesperson gets merchandise, a transaction code is recorded.
When the salesperson swaps the merchandise with another salesperson,
the same
transaction gets recorded for the first salesperson.
Lastly, the next salesperson gets the merchandise, and the same
transaction code is
recorded for them.

So, we have two different salespeople, with two rows that have same
transaction code.

I want to flag the line items when the same transaction is recorded
for two sales people.
I only want to flag the line items when it is traded among two sales
people.

I have tried this:
=b2=b1
I drag the cell down the column.
(It will say TRUE if the transaction code matches the one above).

I have another column that checks to see if the salesperson is
different:
=a2<>a1
(It will say TRUE if the sales person is different.)

I have tried to see if the two conditions say TRUE, but this does not
seem to work:
=if((c1="TRUE") and (d1="TRUE"), "merchandise has moved salesperson to
salesperson")

This does not seem to work. Any thoughts?
Maybe with a conditional format to check the two conditions?

 

[Don Guillett]

I am working on a spreadsheet that tracks salespeople.
I want to show when a salesperson move merchandise to another
salesperson.

Column A has the salesperson code
Column B has the transaction code.

When a salesperson gets merchandise, a transaction code is recorded.
When the salesperson swaps the merchandise with another salesperson,
the same
transaction gets recorded for the first salesperson.
Lastly, the next salesperson gets the merchandise, and the same
transaction code is
recorded for them.

So, we have two different salespeople, with two rows that have same
transaction code.

I want to flag the line items when the same transaction is recorded
for two sales people.
I only want to flag the line items when it is traded among two sales
people.

I have tried this:
=b2=b1
I drag the cell down the column.
(It will say TRUE if the transaction code matches the one above).

I have another column that checks to see if the salesperson is
different:
=a2<>a1
(It will say TRUE if the sales person is different.)

I have tried to see if the two conditions say TRUE, but this does not
seem to work:
=if((c1="TRUE") and (d1="TRUE"), "merchandise has moved salesperson to
salesperson")

This does not seem to work. Any thoughts?
Maybe with a conditional format to check the two conditions?

Look in the help index for AND