| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting/Sorting
Using Excel 2003
I have an Excel report that has over 2,000 rows. I want to delete the rows where the text/numbers are NOT bold and keep the ones that ARE bold. Im not sure if this is possible. If this cannot be done based on that criterion, the rows I want to keep all have a number value in column E. Maybe it's possible to isolate only the rows that have a value in column E. Im not sure how to do this. I would sort the records, but some of the cells I dont want are merged. At least all of the rows I want to keep do not have any merged cells. Is this possible? The range of data is A2:E2169. Any help would be greatly appreciated Thanks, Karen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting and Deleting Help | Excel Worksheet Functions | |||
| Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
| Deleting data by sorting dates | Excel Discussion (Misc queries) | |||
| Sorting and deleting empty cells | Excel Discussion (Misc queries) | |||
| deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
Threaded Mode
