Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2019, 07:11 PM
Bimmie Bimmie is offline How to Filter non-contiguous Columns Windows 10 How to Filter non-contiguous Columns Office 2016
Novice
How to Filter non-contiguous Columns
 
Join Date: Feb 2019
Posts: 5
Bimmie is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 03-01-2019, 11:51 AM
charlesdh charlesdh is offline How to Filter non-contiguous Columns Windows 7 32bit How to Filter non-contiguous Columns Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 03-01-2019, 01:22 PM
Bimmie Bimmie is offline How to Filter non-contiguous Columns Windows 10 How to Filter non-contiguous Columns Office 2016
Novice
How to Filter non-contiguous Columns
 
Join Date: Feb 2019
Posts: 5
Bimmie is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 03-02-2019, 11:54 AM
charlesdh charlesdh is offline How to Filter non-contiguous Columns Windows 7 32bit How to Filter non-contiguous Columns Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Hi,
Post a file so we can see what you are dealing with. Also, what are you excepting to see.
Reply With Quote
  #5  
Old 03-02-2019, 01:35 PM
Bimmie Bimmie is offline How to Filter non-contiguous Columns Windows 10 How to Filter non-contiguous Columns Office 2016
Novice
How to Filter non-contiguous Columns
 
Join Date: Feb 2019
Posts: 5
Bimmie is on a distinguished road
Default

Tried to paste worksheet here... didn't work.
Tried to paste snip-it here... didn't work.
Reply With Quote
  #6  
Old 03-02-2019, 01:36 PM
charlesdh charlesdh is offline How to Filter non-contiguous Columns Windows 7 32bit How to Filter non-contiguous Columns Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Hi,
Try to upload a file.
Reply With Quote
  #7  
Old 03-02-2019, 01:38 PM
charlesdh charlesdh is offline How to Filter non-contiguous Columns Windows 7 32bit How to Filter non-contiguous Columns Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Hi,
You will need to select "Go Advance" this will allow you to select the file you wish to upload.
Reply With Quote
  #8  
Old 03-03-2019, 11:48 AM
Bimmie Bimmie is offline How to Filter non-contiguous Columns Windows 10 How to Filter non-contiguous Columns Office 2016
Novice
How to Filter non-contiguous Columns
 
Join Date: Feb 2019
Posts: 5
Bimmie is on a distinguished road
Default

Thanks, Charles but, I figured it out.
Reply With Quote
  #9  
Old 03-03-2019, 12:42 PM
charlesdh charlesdh is offline How to Filter non-contiguous Columns Windows 7 32bit How to Filter non-contiguous Columns Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

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.
Reply With Quote
  #10  
Old 03-03-2019, 05:39 PM
Bimmie Bimmie is offline How to Filter non-contiguous Columns Windows 10 How to Filter non-contiguous Columns Office 2016
Novice
How to Filter non-contiguous Columns
 
Join Date: Feb 2019
Posts: 5
Bimmie is on a distinguished road
Default

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.
Reply With Quote
  #11  
Old 03-03-2019, 06:17 PM
charlesdh charlesdh is offline How to Filter non-contiguous Columns Windows 7 32bit How to Filter non-contiguous Columns Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Thanks for the update.
Reply With Quote
Reply

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
How to Filter non-contiguous Columns Novice needs: Complicated running totals adding substracting non contiguous cells contiguous columns innkeeper9 Excel 5 08-30-2016 04:43 PM
How to Filter non-contiguous Columns Advanced Filter is leaving out some columns Rod_Bowyer Excel 3 03-13-2016 03:54 AM
How to Filter non-contiguous Columns Filter 2 columns between 2 dates s_samira_21 Excel 2 02-08-2015 10:34 PM
How to Filter non-contiguous Columns Advanced Filter - Comparing Two Columns apolloman Excel 5 07-27-2011 04:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft