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

R

Rhett C

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.
 
F

Fred Smith

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=T1,"None",O1))

It may need further tweaking depending on other examples.

Regards,
Fred
 
R

Rhett C

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top