Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cheryl
 
Posts: n/a
Default Autofilter a list of numbers and blank cells

My report consists of a list of numbers and blank cells in column B and
descriptions in column A. I would like to print the report showing only the
list of numbers in column B and relevant descriptions in column A. Filtering
does not work if the list consists of blank cells in between. thank you
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m
 
Posts: n/a
Default Autofilter a list of numbers and blank cells

This might not be the most efficient way of doing it but I usually will sort
all of the data, this will stick all the blanks at the bottom. Then I just
hilite the cells with data and 'print area'...'set print area'
(If the cells with data need to be in a specific order, before the sorting
to lump the blanks together I will quickly insert a column and data fill it
so I have numbers that I can sort back to.)

"Cheryl" wrote:

My report consists of a list of numbers and blank cells in column B and
descriptions in column A. I would like to print the report showing only the
list of numbers in column B and relevant descriptions in column A. Filtering
does not work if the list consists of blank cells in between. thank you

  #3   Report Post  
Posted to microsoft.public.excel.misc
businesslady24
 
Posts: n/a
Default Autofilter a list of numbers and blank cells


Hi,

If you are using autofilter on your columns, you should be able to
select 'non blanks' from the drop down list. This will omit all blank
cells in column B and only show the relevant data in column A that
corresponds to those cells that are left in column B

HTH


--
businesslady24
------------------------------------------------------------------------
businesslady24's Profile: http://www.excelforum.com/member.php...o&userid=35669
View this thread: http://www.excelforum.com/showthread...hreadid=554606

  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Autofilter a list of numbers and blank cells

"Cheryl" wrote in message
...
My report consists of a list of numbers and blank cells in column B and
descriptions in column A. I would like to print the report showing only
the
list of numbers in column B and relevant descriptions in column A.
Filtering
does not work if the list consists of blank cells in between.


Yes it does. Select the whole list (columns A & B, top to bottom). Data/
Filter/ Autofilter
Hit the filter button for column B and select Non-blanks.
--
David Biddulph


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ghost numbers in blank cells scott Excel Worksheet Functions 2 January 5th 06 07:53 PM
CSV file with 13space characters in blank cells Jim May Excel Discussion (Misc queries) 2 December 6th 05 10:22 PM
enter numbers in blank cells bill gras Excel Worksheet Functions 2 September 21st 05 02:17 PM
How to alter data on HTML webpage into Excell cells as numbers? roameri New Users to Excel 6 August 1st 05 12:42 AM
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 02:48 PM


All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"