Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare formula result with text | Excel Discussion (Misc queries) | |||
Match criteria in two columns and give a third colums result | Excel Discussion (Misc queries) | |||
need result of formula to compare itself to another number andincrease if needed. | Excel Discussion (Misc queries) | |||
compare two columns, then calculate a result | Excel Discussion (Misc queries) | |||
Macro to compare two columns of data | Excel Discussion (Misc queries) |