Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting rows depending on string
Hello,
I have spreadsheet with thousands of records. I need to pull out all records from first coloumn ending with "ic", and have spreadsheet sorted so those records are on the top, or bottom, or create new spreadsheet with searched records and delete them from the old one. If that is not clear enough, I need to split the list into records that have "ic" at the end of first cell, from the rest of records. I have some VBA experience, but never worked with Excell. Thanks! -- Deki PA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Condtional format of row depending on string value of $A2 + | Excel Discussion (Misc queries) | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) |