| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete rows with certain text
Hi!
I want to delete rows in certain with a certain text in the b column. 2704000 528050 0 0 121637 #N/A 0 0 151637 #N/A 0 0 126397 #N/A 0 0 121637 761900 0 0 521537 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Ie in this example i want to remove all columns that have #N/A in them in the B column! How do i do that? Ive tryed mixing some macros but im not so good at them... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| limiting rows of text in a textbox object? | Excel Worksheet Functions | |||
| Macro to delete rows with same data | Excel Worksheet Functions | |||
| Want to delete rows | Excel Discussion (Misc queries) | |||
| Delete all rows where Column A contains Text | Excel Worksheet Functions | |||
| How to create a Pivot table from text file with more than 65000 rows? | Excel Discussion (Misc queries) | |||
Threaded Mode
