#1
|
|||
|
|||
How to Filter non-contiguous Columns
I have a worksheet where column A contains names. Columns B:AF can be blank or contain a integer 1 - 31. Column AG sums each row. THEN, Columns AH:BL contain the same as noted for Columns B:AF and Column BM contains the sum of each row between AH:BL.
What I'm trying to do is filter Columns A:AF where AG is <0. This I can do without a problem. I'm stuck at the moment trying to filter Columns AH:BL where BM is <0 AND include Column A in this filter. Not looking to do this all at once as I'm happy to run two filters or what-have-you. I just need to have Column A included in the 2nd Filter pass. Not even sure this can be done with a filter so, that's why I'm posting here. |
#2
|
|||
|
|||
Bimmie,
It may be easier for the forum if you attach a workbook. I did some research and it appeares that you can not filter "Non Contiguous Columns" Last edited by charlesdh; 03-01-2019 at 12:07 PM. Reason: Added Info |
#3
|
|||
|
|||
Thanks for researching this issue, Charles.
I was hoping I could filter columns A-G or columns I-O independently but it looks like I'll have to come up with another solution. |
#4
|
|||
|
|||
Hi,
Post a file so we can see what you are dealing with. Also, what are you excepting to see. |
#5
|
|||
|
|||
Tried to paste worksheet here... didn't work.
Tried to paste snip-it here... didn't work. |
#6
|
|||
|
|||
Hi,
Try to upload a file. |
#7
|
|||
|
|||
Hi,
You will need to select "Go Advance" this will allow you to select the file you wish to upload. |
#8
|
|||
|
|||
Thanks, Charles but, I figured it out.
|
#9
|
|||
|
|||
Bimmie,
Thanks for letting us know. I'm assuming you set the filer for the first occasion which showed the filtered value then you kept the same filtered values and the set the same filter for the second value. |
#10
|
|||
|
|||
What I missed early on was that the top 3 rows of my worksheet had some merged cells. They prevent you from filtering columns. When I noticed that, I figured out that I could select the 4th row and filter from there.
Solved my problem. |
#11
|
|||
|
|||
Thanks for the update.
|
Tags |
excel 2016, vba code |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filter by multiple columns | ConfuddledOne | Excel Programming | 0 | 01-30-2017 08:00 PM |
Novice needs: Complicated running totals adding substracting non contiguous cells contiguous columns | innkeeper9 | Excel | 5 | 08-30-2016 04:43 PM |
Advanced Filter is leaving out some columns | Rod_Bowyer | Excel | 3 | 03-13-2016 03:54 AM |
Filter 2 columns between 2 dates | s_samira_21 | Excel | 2 | 02-08-2015 10:34 PM |
Advanced Filter - Comparing Two Columns | apolloman | Excel | 5 | 07-27-2011 04:54 AM |