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. |
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. |
All times are GMT +1. The time now is 05:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com