filter criteria

  1. G

    autofilter <= not working

    Hi, I am trying to filter two columns, one an effective date, the second an expiry date, to filter permits that were valid for a particular year. As the year of interest changes I have set up a userform which I can enter the year of interest. I am successfully able to get the first filter >=...
  2. C

    Filter by Customer and select 20 Materials

    Hi Guys, I would like to request your help with this macro. I tried several times but I'm not sure how to do that . I need to filter for a customer and select 20 materials minimum for each one. Note : I have around 100 different customers Customer Materials...
  3. S

    Macro to filter a query based on user input

    Hello, I never excel scripted before.. so I am looking for some help with a macro, I created a workbook with a company inventory of all IT items.. each sheet has a listing of a certain type of device (workstations/switchs/keyboards/monitors/printers ect). I have a query that is activated by a...
  4. S

    Auto-Filter if contains Array

    I am working on a series of Gantt chart reports where one of the requirements involves the end-user entering one or more "employees" to view all of the programs assigned to them. I can’t seem to filter on the Lead/Test field if the cell isn’t exact. I am also filtering only on the last...
  5. M

    Macro to Filter Criteria Based on Table

    I am trying to filter out data based on specific data that changes based on location, I am trying to see if their is a way to adjust the filter code to use the data on a list I created as the filter criteria, once it has gone through the whole list it would continue with the rest of the macro...
  6. B

    Custom ADV Filter with IF Function

    I'm trying to use a adv filter to pull out, in a separate table, items from a table which meet a criteria based on a formula ie. the criteria should look at 'starting column' F, and is only if that number is smaller than the sum of columns D & E. If tried a IF Formula but cant seem to get it...
  7. Y

    Filter by Selection

    Can anyone point me in the right direction to write a macro that filters my table by the values currently selected? Currently, to filter my data I have to click the filter arrow on ColumnA, un-select the "select all" box, then scroll through the list to select the value I want to use in the...
  8. B

    Macro to hide entire row if value from 2 columns are blank

    Hello, I require a macro to hide entire rows based on the criteria of having blank values in BOTH columns C & D. Thanks in advance BENR
  9. K

    Filter with multiple criteria in VBA

    Hi The following code is quite straight forward and looks for 2 criteria using a filter within some data but I need it to look for more than 2 criteria now as the report is growing... Selection.AutoFilter Field:=10, Criteria1:="=SERCO", Operator:=xlOr, _ Criteria2:="=NG" I have...
  10. R

    AutoFilter not recognizing values

    I have an autofilter setup with 3 values: "Show", "Hide" and "Always". The show/hide values are dependent if formulas based on other cells. I have two sheets with this filter (Template and Summary); the filter works fine on the Template tab, however on the Summary tab... When filtered to...
  11. J

    Advanced Filter Help - I DARE YOU TO SOLVE THIS ONE!

    Hi guys and girls, sorry for the re-post but I just figured out how to share my file on Windows SkyDrive.!102 In the attachment you will find a list of products named "list." The first column is the product...
  12. J

    Advanced Filter Criteria Range Help

    I have a master list of all of our parts for our inventory system as seen below <TABLE style="WIDTH: 959pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1279><COLGROUP><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH...
  13. E

    How to get one last record of flow of data

    Hi everyone, I can't figure out how to do that: I have the records of a flow of foretasted price. Means that every 2 minutes I have new price coming for the same point of time in the future. My goals is to extract of every period of time the latest foretasted point. As the last forecast should...
  14. J

    Filtered pivot tables for multiple sheets

    I have 3 sheets, all with the same headings. I need a pivot table which can take the data from all three sheets. <TABLE style="WIDTH: 326pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=435><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 62pt...
  15. H

    Macro to filter 1 column and delete

    I'm trying to improve my macro to run a filter on Col Y and delete specific values. Col Y can be "DT", "IO", "PS", "RO", "TI", "TO", "WO", "ZZ" "(Blank)" but I only want to keep "IO", "PS", "RO". I tried putting a space into each cell in the entire row where there is a value I want to delete...
  16. I

    Complicated filter question

    Hi there, I know absolutely nothing about excel and I have quite a difficult – for me at least – thing I want to do. I have a file in which every row has 40 columns, and in some rows all the columns are filled in, in some only one, some multiple, you get it. What I want to do is filter the file...
  17. C

    Filter on text within a column of phone numbers

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
  18. J

    permanently filter out cases and analyse data on a case-by-case basis

    Hello! Would appreciate any help...have searched the previous posts without luck... Am using Excel XP Q1: i want to filter out duplicate cases in a specific column where constant data e.g. 'age' is unchanged for a particular case. I have tried C&P to a separate doc, advanced filtering showing...
  19. C

    Moving Down in Filtered Area VBA

    Hello Everyone, I have a fairly standard macro that uses autofilters using different variables to filter out the data, but then after that it needs to manipulate the rows that still visible, I have found this basic code from other posts that moves down the data untill it reaches a visible row...
  20. B

    Linking Data to another sheet after Filtering

    First I want to say thank you for everyone on here. I am not new to excel, but I am new to what it can actually do. From reading the posts on here I have learned a lot about how powerful excel really is. I have been creating a spreadsheet that enables engineering to sort thru a large amount of...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back