Sorting Data Automatically

  • Thread starter Thread starter Alan Bartley
  • Start date Start date
A

Alan Bartley

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
 
Hi Alan

not sure how the sorting comes into this - sounds more like needing a
formula to count when a cell contains both QR & QT as opposed to just
containing QR???

to count the number containing both QR & QT try
=COUNTIF(A1:A4,"*QR*QT*")
to count the number containing only QR
=COUNTIF(A1:A4,"*QR*")-COUNTIF(A1:A4,"*QR*QT*")

Cheers
JulieD
(Perth)
 
You must log in or register to reply here.

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

Similar Threads

Enter 8 x digit figure to return dd/mm/yyyy (with parenthess) 1
Sorting Automatically 3
Can I sort text data by reference to text data in another column? 1
Data validation 3
Search/Match between 2 x separate Worksheets and populate result in third worksheet 1
Basic sort question - maintain relationship across columns 6
data sort while maintining reference with cell in different worksh 1
auto sort macro 1

Back
Top