View Single Post
  #1   Report Post  
Alan Bartley
 
Posts: n/a
Default Sorting Data Automatically

I am importing text into a new worksheet and would like to run a macro
that can perform labour a labour intensive sort/deletion.

Column A contains a mixture of text strings as follows:

QR4567
QR4567/QT1223
QR4290
QR4290/QT1224

What I would like to do is determine how many QR's have associated
QT's and how many QR's are remaining that dont have associated QT's.

Any assistance would be greatly appreciated.

Alan Bartley
Sydney Australia