View Single Post
 
Old 11-18-2015, 01:44 PM
Learner7 Learner7 is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default How to write a formula to simplify the work?

The following is the example data:

TA-151700001.06
SER

TA-151700001.07
SER

TA-151700001.08
MP
SER

TA-151700002.06
SER

TA-151700002.08
MP
SER

TA-151700001.01.01
SER

TA-151700001.02.01
MP
SER

And this is the result I need:

TA-151700001.06 SER

TA-151700001.07 SER

TA-151700001.08 MP
TA-151700001.08 SER

TA-151700002.06 SER

TA-151700002.08 MP
TA-151700002.08 SER

TA-151700001.01.01 SER

TA-151700001.02.01 MP
TA-151700001.02.01 SER

What I need is, the data below TA-15170000* which is "MP" OR "SER" or both should be like the above.

Please help.
Reply With Quote