ExcelBanter - show nonblanks

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - show nonblanks (https://www.excelbanter.com/excel-discussion-misc-queries/113111-show-nonblanks.html)

Hamid

show nonblanks

How can we instruct excel to show nonblanks in a cloumn of data?

Gord Dibben

show nonblanks

Please provide more detail of what you need Excel to do.

Maybe DataFilterAutofilterClick on a drop-down arrow and select Non-Blanks
from the options.

Gord Dibben MS Excel MVP

On Thu, 5 Oct 2006 19:38:02 -0700, Hamid
wrote:

How can we instruct excel to show nonblanks in a cloumn of data?

All times are GMT +1. The time now is 05:31 PM.