Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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) "Alan Bartley" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colors of columns after sorting data in the supporting table | Charts and Charting in Excel | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |