Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automatically filter out blanks in multiple columns
I have a spreadsheet with numerous columns (different job #'s), and under
uner job is a list of supplies needed. Is there any way to automatically filter out blank cells of all the columns at the same time? -- gmr7 |
#2
|
|||
|
|||
You could add a column to the table, and use it to count the number of
jobs that have an entry in that row. For example, in cell M2, enter: =IF(COUNTA(B2:L2),"Yes","No") Copy the formula down to the last row of data. Then, filter column M for Yes or No. gmr7 wrote: I have a spreadsheet with numerous columns (different job #'s), and under uner job is a list of supplies needed. Is there any way to automatically filter out blank cells of all the columns at the same time? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
http://www.contextures.com/AdvFilterRepFiltered.xls
This macro is what I am looking for. However my sheet is based on 6-digit job numbers (in lieu of "rep"). The macro works for the 1st run, but when I change a job number or add a new job number, it is giving me an error run-time error '9'; Subscript out of range Any advice?? -- gmr7 "Debra Dalgleish" wrote: You could add a column to the table, and use it to count the number of jobs that have an entry in that row. For example, in cell M2, enter: =IF(COUNTA(B2:L2),"Yes","No") Copy the formula down to the last row of data. Then, filter column M for Yes or No. gmr7 wrote: I have a spreadsheet with numerous columns (different job #'s), and under uner job is a list of supplies needed. Is there any way to automatically filter out blank cells of all the columns at the same time? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Way to put multiple rows into the same column. | Excel Discussion (Misc queries) | |||
how do I filter for 1 variable in multiple columns | Excel Worksheet Functions | |||
same cell from multiple sheets into one column | Excel Discussion (Misc queries) | |||
Column widths to adjust automatically? | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |