Thread: How do I pick up only the rows with a non-null key column on a separate sheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scoops Scoops is offline
external usenet poster
  
Posts: 108
Default How do I pick up only the rows with a non-null key column on a separate sheet?

qcc wrote:
Hi,
I want the report on sheet 2 look like: (picking only the people with
telephone numbers)

name telephone
AAA (111)-777-9999
CCD (888)-999-0098

How do I make this work?

Hi qcc

Just a thought...

Why not use Data Filter Auto Filter, click the drop down arrow in
the Telephone column and click (NonBlanks)?

Gets the result you want without having to create a new sheet of data.

Regards

Steve

Reply With QuoteReply With Quote