advanced filtering

  1. S

    How to make/create OR operator between fields in Power BI ?

    So I have 2 fields Problem Work Performed Both can contain similar information, thus both can contain specific info. So far apps provide only AND operator. If I create filter for Problem and Work Performed. I will either miss information if one of the fields doesn't contain keyword, or I don't...
  2. A

    Advanced Filter Macro Help

    Morning all. I have a column on sheet 1 with different numbers in it (150, 300, 600, 900, 1500, 2500) ad would like to filter it based on the number given on sheet 2, cell B5 (I have the criteria listed on sheet 2 as well). I've tried manually writing the advanced filter macro, and when that...
  3. B

    Pivot Table Filtering

    Hi All, I'm looking for a way (if possible) to allow my filters in a pivot table be based off of an "if" statement or something similar. The data that i'm pulling from is a little complicated to write out... but here goes nothing. I work at a hotel and every night there is a snap shot of what...
  4. L

    Advanced Filter for all colours on multiple columns

    Hi there, I am wanting to create an advanced filter to sort multiple coloured columns on a filter set from A1:Z1. The spreadsheet is a document that has been created to find any issues with any of the data in the document and highlights when there is an issue. The colours are often different...
  5. J

    Advanced Filter

    Hellloooo Friends.. Can someone help me debug my Advanced filter. My end goal is to hide all rows that do no have "ABCD-201,ABCD-202,ABDC-203" in column A. 'Start my filters 'creating a Advanced filter to find ABCD With Sheets(2) .Range("AR1").NumberFormat =...
  6. A

    Advanced IF/THEN Statement OR Advanced filtering

    Scenario: Within same workbook, two tabs of data that need to be extracted to a third tab. Tab 3 - Master file 35K rows Tab 2 - Will very monthly Tab 1 - end result What I would like to do is: Using Tab 2, compare to Tab 3 master, if column B is equal in both tabs, then I would like to see...
  7. C

    Filtering with VBA out of user forms.

    Good morning, I'm creating a spreadsheet with a userform to filter data. The afflicted portion of the userform is basically just a bunch of comboboxes stacked on top of each other. The combo boxes are populated from several different tables. After the first combobox is selected, I'm hoping to...
  8. S

    VBA For Advanced Filter Auto-Update on Multiple Sheets

    Hi, I have a workbook with over 50 Sheets. I have set up advanced filters on in excess of 30 sheets. I would like to find a way to use VBA code to update the existing advanced filters that i have set when there is a chance to the woorkbook. I have managed to enter some code but it is based...
  9. K

    Filter Data based on two cells

    Hello: I have a report that is being dumped into excel. From that data, I have a Index Formula that is returning data based on client. When that data returns I need to be able to filter by date. I need to be able to type the date range in two separate cells. <tbody>...
  10. J

    VBA Search Row Return in Different Worksheet

    I am new to VBA code, I am trying to create a search with 10 criteria in a userform, 2 of which are a start date and end date and the other 8 are categories and sub categories and descriptions. I want the option to leave some or all of the search criteria blank and return the full row of any...
  11. M

    Advanced Filter that Add Row Between Each Newly Encountered Criteria

    Very new. First Post. I am building a tool for a manager to input employee schedules, see total hours and dollars in real time, and push out a csv file that will later be uploaded into our clock in system. So far, so good. I have an advanced filter that pulls data for each employee based on...
  12. K

    Advanced Filtering VBA based on cell value

    Dear all, I am working on a global email communications report covering 12 markets. As per the screenshot attached, I would like to filter results based on the cell value in D3 ("Austria") whereas D3 is a drop-down listing all 12 markets in two variants (one is just the market e.g. "Austria"...
  13. M

    Applying saved filters/custom views to multiple worksheets (Excel 2010)

    Hi everyone, I am trying to analyse large amounts of ticketing data using Excel 2010. For each quarter, I need to separate about 120,000 rows of data into the following groups (and then save them to a new worksheet): <tbody> Adult only Senior Only Adults & Seniors Adults & Concessions...
  14. J

    Filter One Spreadsheet with Another

    Hi, I would like to filter one spreadsheet (inventory) with Item numbers from another spreadsheet (orders). My ideal situation would be to highlight the item numbers on the "Orders" spreadsheet, and then run a macro/vba script that will filter the list of items in the "Inventory" spreadsheet...
  15. L

    Use of wildcards in advanced filtering.

    I have an old macro that lets me do an advanced filter on a table orginating in SQL. Because of a change in the values in the field i need to use wildcards. Before i had values like below Category SmG SmG/LTM SmG/Trade This was handlet with a filter that gave me all those with: Category SmG...
  16. J

    Advanced Filter not coping Hyperlinks

    Hi, I am using Advanced filter to filter the data to a different location in the same book using a small macro code. The primary datasheet has working hyperlinks, although when the advanced filter copies the data to another sheet the text remains formatted but there are no hyperlinks...
  17. S

    VBA Advanced filter Dynamic Ranges

    Hi All, Just needing some help on this. The range element below needs to be dynamic. A1 and down meaning if i was to do this out of VBA I would hold CTRL+SHIFT+DOWN but i cant do that from macro record as it doesn't work, I'm guessing this Range("A1:A73") is the element I need to change but I...
  18. Y

    Filtering Out entire row if all columns of values have all zeros

    I have searched the many threads of this forum that have similar questions, but I have not found what I really need. I have a sheet that pulls values from another sheet based on user selections. For the years selected, say 2014 to 2050 (37 columns), if all of the columns for that entry (Product...
  19. C

    Issue with Advanved Filter Wildcard! please help!

    Hi all, I am working on my advanced filter. I would like to find all date records that contain 2014. The issue is that some records contain Q1 2014, Q2 2014, etc and others have 2014 strictly as date. If i type in "2014" in the crteria ecxel will return all 2014 records BUT NOT q1 2014 nor q2...
  20. M

    Problem with Advanced filtering not filtering

    I have a workbook with several pages of data. What I am trying to do is repair a macro written by someone many years ago which has fallen over and probably been tinkered with by other people over the years. One tab has a form which when a particular job number is entered, looks up a job list...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top