| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I pick up only the rows with a non-null key column on a separate sheet?
Thank you Steve. This makes my life much easier! -- qcc ------------------------------------------------------------------------ qcc's Profile: http://www.excelforum.com/member.php...o&userid=36588 View this thread: http://www.excelforum.com/showthread...hreadid=563296 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function and compare | Excel Discussion (Misc queries) | |||
| Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Linear Mode
