| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing single items from list
I'm trying to figure out if there is a way to remove the non duplicate items
from my list. I have a rather large list that is separated by blank lines. Sometimes there is a blank line, a line of data and another blank line. Other times there is a blank line, 2 or more lines of data, then a blank line. Can I write a formula in G5 that says if F4 and F6 are blank give me "*".. then filter for the stars and delete those lines? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing duplicate data from a single list | Excel Worksheet Functions | |||
| Removing items from worksheet by account number question | New Users to Excel | |||
| How do I link all the items in a single row? | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Removing single quote from an excel sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
