Macro or formula to compare columns and give a result of the odd o
 

User State Plate User State Plate User State Plate
jmolini OK 2MO980 mboulette OK 2MD980 jbradley OK 2MO980 1
jmolini TX 30VVF8 dfoose TX 60VVF8 awright TX 30VVF8 1
jmolini TX 4D0U558 dherrera CA 4DOU558 awright CA 4DOU558 1

I need to compare entry from three different users. The user names are in
columns L, O, R.
I need to compare M and N, to P and Q, to S and T, which ever one is
different, I need that User name inserted into column M. In my example, line
one, mboulette (P and Q) would be the one different and the user name would
need to be copied to column V (mboulette).
Please help me with a macro of formula, I have a spreadsheet of 1000 to 2000
rows each day and it takes me 3 hours.

Thanks for your help.

Macro or formula to compare columns and give a result of the odd o
 

With the data you had, I came up with the following formula for V1:
=IF(N1=Q1,IF(N1=T1,O1,IF(Q1=T1,"None",R1)),IF(Q1=T 1,"None",O1))

It may need further tweaking depending on other examples.

Regards,
Fred

"Rhett C" wrote in message
...
User State Plate User State Plate User State Plate
jmolini OK 2MO980 mboulette OK 2MD980 jbradley OK 2MO980 1
jmolini TX 30VVF8 dfoose TX 60VVF8 awright TX 30VVF8 1
jmolini TX 4D0U558 dherrera CA 4DOU558 awright CA 4DOU558 1

I need to compare entry from three different users. The user names are in
columns L, O, R.
I need to compare M and N, to P and Q, to S and T, which ever one is
different, I need that User name inserted into column M. In my example,
line
one, mboulette (P and Q) would be the one different and the user name
would
need to be copied to column V (mboulette).
Please help me with a macro of formula, I have a spreadsheet of 1000 to
2000
rows each day and it takes me 3 hours.

Thanks for your help.

Macro or formula to compare columns and give a result of the odd o
 

I'm sorry, correction, "I need that User name inserted into column M" it
should be column V. Thanks

"Rhett C" wrote:

User State Plate User State Plate User State Plate
jmolini OK 2MO980 mboulette OK 2MD980 jbradley OK 2MO980 1
jmolini TX 30VVF8 dfoose TX 60VVF8 awright TX 30VVF8 1
jmolini TX 4D0U558 dherrera CA 4DOU558 awright CA 4DOU558 1

I need to compare entry from three different users. The user names are in
columns L, O, R.
I need to compare M and N, to P and Q, to S and T, which ever one is
different, I need that User name inserted into column M. In my example, line
one, mboulette (P and Q) would be the one different and the user name would
need to be copied to column V (mboulette).
Please help me with a macro of formula, I have a spreadsheet of 1000 to 2000
rows each day and it takes me 3 hours.

Thanks for your help.