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

Hi,

I want to make a report on a separate sheet based on a non-null column
on another sheet. Example:

sheet 1:

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

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?

Thank you very much for your help!

qcc


--
qcc
------------------------------------------------------------------------
qcc's Profile: http://www.excelforum.com/member.php...o&userid=36588
View this thread: http://www.excelforum.com/showthread...hreadid=563296

Reply With QuoteReply With Quote