| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula to filter out blanks
Hi,
I'm looking for a formula that will filter out blank cells in a list of text data. I would like to list the new data on a separate tab and also include duplicates if possible. thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula to filter out blanks
On Nov 25, 11:22*am, jt wrote:
Hi, I'm looking for a formula that will filter out blank cells in a list of text data. I would like to list the new data on a separate tab and also include duplicates if possible. thanks in advance. Just use datafilterautofilterfilter for blankscopy/paste. Record a macro while doing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter non-blanks before closing | Excel Discussion (Misc queries) | |||
| Filter between 2 dates and blanks | Excel Discussion (Misc queries) | |||
| advanced filter for blanks | Excel Discussion (Misc queries) | |||
| Blanks non blanks in filter | Excel Discussion (Misc queries) | |||
| Blanks non blanks in filter | Excel Discussion (Misc queries) | |||
Linear Mode
