I'll this agian>>How do I NOT PRINT a "ROW" that doesn't hav

CAPT.PT · Mar 18th, 2002, 01:00 PM

People have told me to "autofilter" ....that has to do with "COLUMNS"...I have rows assigned various info....if there is no info in the certain ROW..how can I have it not print an empty Row??? The row will have a name and a personnel #..but after that no info...and I don't want to print rows with no other info/data!
There are certain reasons with the Finace department that they want a row or line with just certain info on them..otherwise, yes, I could use custom autofill.

thank you

Steve Hartman · Mar 18th, 2002, 01:09 PM

The autofilter is still the way to go.

Use the column that first contains no data(sounds like the third one if i'm reading this right) as your filter criteria and filter for rows that aren't blank. (Non-Blanks is the actual filter choice)

[ This Message was edited by: Steve Hartman on 2002-03-18 12:12 ]

CAPT.PT · Mar 18th, 2002, 02:22 PM

Steve...thank you for your quick reply....but..the first cloumn may not have any data(say its D6, but Q6, has data)so I would want that row printed.
do you understand?
Maybe this would help..say a6--d6 contains data, like first name,last name, depart. etc., if there is no data in E6 to m6...but P6 has data, so the row needs printed!
If there is no data in rows E6 to W6, then do not print row!

thanks again

Steve Hartman · Mar 18th, 2002, 02:39 PM

If you can add a column, autofilter is still the way to go. Using your example, put =COUNTA(e6:w6) in Y6 and copy down Y for all youyr rows. Then autofilter the whole mess using Column Y as the criteria and filter on >0. =COUNTA() will return a 0 if the row is empty.

[ This Message was edited by: Steve Hartman on 2002-03-18 13:40 ]

[ This Message was edited by: Steve Hartman on 2002-03-18 13:47 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 01:00 PM	#1
CAPT.PT New Member Join Date: Mar 2002 Posts: 32	People have told me to "autofilter" ....that has to do with "COLUMNS"...I have rows assigned various info....if there is no info in the certain ROW..how can I have it not print an empty Row??? The row will have a name and a personnel #..but after that no info...and I don't want to print rows with no other info/data! There are certain reasons with the Finace department that they want a row or line with just certain info on them..otherwise, yes, I could use custom autofill. thank you

Mar 18th, 2002, 01:09 PM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	The autofilter is still the way to go. Use the column that first contains no data(sounds like the third one if i'm reading this right) as your filter criteria and filter for rows that aren't blank. (Non-Blanks is the actual filter choice) [ This Message was edited by: Steve Hartman on 2002-03-18 12:12 ]

Mar 18th, 2002, 02:22 PM	#3
CAPT.PT New Member Join Date: Mar 2002 Posts: 32	Steve...thank you for your quick reply....but..the first cloumn may not have any data(say its D6, but Q6, has data)so I would want that row printed. do you understand? Maybe this would help..say a6--d6 contains data, like first name,last name, depart. etc., if there is no data in E6 to m6...but P6 has data, so the row needs printed! If there is no data in rows E6 to W6, then do not print row! thanks again

Mar 18th, 2002, 02:39 PM	#4
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	If you can add a column, autofilter is still the way to go. Using your example, put =COUNTA(e6:w6) in Y6 and copy down Y for all youyr rows. Then autofilter the whole mess using Column Y as the criteria and filter on >0. =COUNTA() will return a 0 if the row is empty. [ This Message was edited by: Steve Hartman on 2002-03-18 13:40 ] [ This Message was edited by: Steve Hartman on 2002-03-18 13:47 ]