advanced filter

  1. J

    Advanced Filter Comparing Two Columns

    Is it possible to use "Advanced Filter" to compare two columns in the data range and keep if the values are the same? Trying to use Advanced Filter and avoid creating another column of data with which to do my comparison. For example, I want to compare columns M and S and keep the rows where...
  2. L

    Filter words only not containing.

    Hello, i am wondering how to filter words in a data set. e.g men, male without it being part of other words (lament, female etc). Is there a way of using advanced filter for this rather than a formula? Thankyou
  3. X

    How to exclude rows that have empty cell in Col G AND have 0 in Col H with Advanced Filter?

    So I want to filter out all rows that meet the following condition in the title. How would I do that with the Advanced Filter?
  4. X

    Using Advanced Filter to filter out rows where Column H is blank and Column G is 0.

    So it seems I am having trouble setting up the criteria I would use to filter out rows where Column H is blank and Column G is 0. Both these conditions need to be met for that row so it can be filtered out. Can anyone share how they would create the criteria?
  5. A

    Excel Advanced Filter, Clear/.ShowAllData leaving weird formatting

    Hi Everyone, I've got a couple of issues with a search function I'm building. The first is that sometimes the filter won't return all available results. This is something that I've only come across as I've been trying to figure this issue out and made a new sheet with a smaller data set to try...
  6. H

    Filter with multiple criteria dropdown list

    Hello, I am currently working on a spreadsheet with many data, including a dropdown list with multiple selection (I used a VBA code to activate it). Now, on another sheet, I need to extract data from the initial one by using the dropdown list as a criteria, but the advance filter is not...
  7. A

    Advanced Filter: contains specific text

    I put together an advanced filter to only show rows that match my selection from a drop-down menu. I used function =IF(E6=“”,”*”,E6) and recorded a macro to extract data from one sheet and display in my filtered table on another sheet. It works well, but I’ve run into a wall. I have some cells...
  8. BPW

    VBA - xlFilterCopy/CopyToRange - Paste Special to retain destination formatting?

    Hi Everyone, I'm stuck and need a little guidance. I'm attempting to copy unique values within a column of one worksheet and paste them within another worksheet (same workbook) retaining the destination sheet's formatting. Below is the VBA that pastes over the formatting. Sub...
  9. B

    Filter Column based off another Column List

    Hi Everyone, If I wanted to filter data that was in Column AH by data provided from Column AC how would I do that? Let's say Column AH has 50 values while Column AC here has 10. I want to filter using Column AC first value (YOG6LOHSP) to show all of the same values in Column AH(YOG6LOHSP)...
  10. T

    Filter loop through macro

    I have various workbooks that I need to check the data in by filtering on various columns to find those that need to be checked and then I filter through the resultant list using usually column 'C', checking line by line and marking those 'done'. What I'd like to achieve is a button that...
  11. D

    Search for a column and filter 3 or more names with wildcards

    Hi Friends, I request your help here for a code to search for a column using column name and filter data using wildcards. ABC, PQR, and XYZ are part of the same team but no other column to identify teams and therefore they need to be searched at once from the given data. Below code was...
  12. K

    Problem with Advanced filter in excel 2007

    Hello, i cant find what Iam doing wrong, I have quiet complex table (9199 rows actually and colums from A to FE) I wish to use just 2 columns for filtering, but i need to get few combinations of data extracted. 1st column iam using for criteria should search for like values Data1 - Data6 and...
  13. H

    Advanced filter from another workbook

    Fluff very kindly posted the following code to enable the automation of advanced filtering from one worksheet to another in the same workbook for variable criteria without having to reinput the criteria each time. But how would this be done from another workbook? The data is in a workbook...
  14. M

    Advanced Filter

    How would you set up advanced filter if you want to collect records of a dataset that contain numbers stored as text, and you want them starting with the partial text 646&"*" or 647&"*". I have a dataset where a column contains account code in text format such 6****** and I want all of those...
  15. G

    Mixing Advanced Filters and Normal Filters

    Good afternoon! So I am trying to sat up an automatic report for my job where I can use advance filters to type the selected months into the criteria page and have it filter per those months. The macro however uses both Advanced and Normal filters and when I transition between, the entire table...
  16. R

    Excel VBA: First execution of Advanced Filter returns header, and then the filtered results

    I have an Advanced Filter set up in my spreadsheet, and rather than showing all of the filtered results at once, I have it set up so it cycles through them one by one. But I have noticed that the first time I click the button that executes the script, it returns the header value first and then...
  17. R

    Excel VBA Advanced Filter Multiple Comboboxes Userform Listbox - How to?

    Hi I'm a first time poster so apologies in advance if any of the below is not allowed or does not make sense etc. I'm more than happy to amend it/clarify anything. I have a userform which allows me to view values in worksheet1 using a listbox. I have several textboxes on the userform which...
  18. 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...
  19. S

    Find Replace from a list of words

    Hello! I can't seem to be able to find any help in regard to this, nor can I find any excel add-ons that can do this seemingly easy task. I have a huge list of URL's on my spreadsheet, and I need to remove certain domains such as social media sites and various others. I can do this manually...
  20. R

    VBA Advanced Filter

    I have some code that currently looks for two criteria. <colgroup><col><col></colgroup><tbody> Date Requested Approved? 2/24/2019 Approved </tbody> I would like to add pending as a criteria under approved too. so that if the column has approved or pending it will show up. bellow is what i...

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