Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying filtered data
Looking for any suggestions on how to handle this - I have a
spreadsheet with data which includes a column titled COMMENTS which may or may not have a 30-40 character comment entered. Other information is being captured as well. I'd say no more than 10% of the data includes comments. I will be using a filter to select the data by date. I would like to string all the rows with comments into on area so that these can be printed. I do not want to include the rows without comments entered. I obviously could do this on a one time basis. Want I was hoping for was some other insight on how to do this on an ongoing basis as the filter changes. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying filtered data
Use Data Filter Autofilter and choose "Non-Blanks" from the drop down
arrow on the column which has the comments........ hth Vaya con Dios, Chuck, CABGx3 "mar10" wrote: Looking for any suggestions on how to handle this - I have a spreadsheet with data which includes a column titled COMMENTS which may or may not have a 30-40 character comment entered. Other information is being captured as well. I'd say no more than 10% of the data includes comments. I will be using a filter to select the data by date. I would like to string all the rows with comments into on area so that these can be printed. I do not want to include the rows without comments entered. I obviously could do this on a one time basis. Want I was hoping for was some other insight on how to do this on an ongoing basis as the filter changes. Any ideas? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying filtered data
unfortunately I need to do some calculations on other data by date -
regardless if there is any info in the COMMENT column. I may end up needing to do some MACRO to accomplish what I want. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying filtered data
Perhaps you could do the "date" AutoFilter first, then do the "comments"
AutoFilter... Vaya con Dios, Chuck, CABGx3 "mar10" wrote: unfortunately I need to do some calculations on other data by date - regardless if there is any info in the COMMENT column. I may end up needing to do some MACRO to accomplish what I want. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count certain records in filtered data | Excel Discussion (Misc queries) | |||
REPOST: Count certain records in filtered data | Excel Discussion (Misc queries) | |||
Using ONLY the data filtered | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |