Stack Overflow
Stack Overflow

Questions tagged [advanced-filter]

An advanced query can be achieved through Data ► Sort & Filter ► Advanced. The command can reproduce SQL query-like results with both AND and/or OR criteria.

The Advanced Query command will gain new functionality with the addition of Power Query to Excel 2010+ versions.

More Information at

Create an advanced query (Power Query)
Microsoft Power Query for Excel Help
 

72 questions
4
votes
1 answer

Advanced filter error

I am trying to create a unique list but the first value in the list is a blank and that seems to be causing me a problem. When I use a basic advanced filter it essentially just names the range 'Extract' and copies the formatting. So F2 equals…
SozDaneron
  • 165
  • 1
  • 14
3
votes
2 answers

VBA Advanced AutoFilter + Create new sheets based on range

I need to create new tabs in a workbook based upon a range of cells in a worksheet template. I also want to delete rows of data that do not match the tab name. For example, from the table below I would have a new tab named "2206 - 6" and only data…
Aimaria
  • 33
  • 6
3
votes
1 answer

Get Unique Values Using Advanced Filters Not Working?

I have two sheets: Sheet 2: Column C Supplier Name A A B B C Sheet 1 (Desired Result) Column G A B C I am trying to create a list of unique supplier names in column G on Sheet 1, as shown above. I am using this code: Sub LIST() Dim r1 As…
user7415328
  • 953
  • 3
  • 16
  • 48
3
votes
1 answer

Excel : filter with Multiple Criteria : AutoFilter or AdvancedFilter

I am trying to create a filter that will do the below Begins with "4" or Contains "2TWH" or Contains "2TER" I believe it will turn out to look like this ActiveSheet.Range("$A$5:$H$10").AutoFilter Field:=2, Criteria1:="=4*", _ Operator:=xlOr,…
Mathew Hood
  • 655
  • 1
  • 7
  • 19
2
votes
1 answer

Speeding up copying from another sheet in VBA using advanced filter

I'm very new to VBA and this community so I hope I'm not asking any stupid question and I apologize beforehand if the phrasing of my question isn't up to the standards. I've been working on a code with the intention of going through a column and…
Hamza Oulmouden
  • 23
  • 3
2
votes
0 answers

Simulate AdvancedFilter CriteriaRange Object through array

Background This could end up being a rather silly question, however I wish to still ask it to be sure. As of recently I been introduced to AdvancedFilter through VBA, and reading the CriteriaRange parameter takes a Variant data type I thought it may…
JvdV
  • 41,931
  • 5
  • 24
  • 46
2
votes
1 answer

How do I loop through criteria in Advanced Filter?

I'm trying to filter a table based on a criteria and copy&paste the result to a different sheet. Basically I have a huge amount of data stored in one sheet("Department ERP") and I need to filter column("GLO_MASS_LINE") based on a criteria, then…
Martin Hvězda
  • 21
  • 1
2
votes
0 answers

AutoFilter is turned off after an AdvancedFilter is applied

Let's say I have a Range("A1", "D13") in my Worksheet("Sheet1") with data. Some data in the first column are repeating, meaning not unique for the column. Now as my first action, I create an .AutoFilter for that range: Dim Ws As Worksheet Set Ws =…
ardavirus
  • 87
  • 5
1
vote
1 answer

Is there a way to use "Not equal to" when using AdvancedFilter in VBA

My problem is quite simple, but I haven´t been able to find a solution that works anywhere. I want to filter out all values in one range that are present in another range - something like this: SheetA.Range("C1:C" & LastRowA).AdvancedFilter…
Magnus
  • 23
  • 4
1
vote
2 answers

AdvancedFitler Out Values from ListRange using Formula

I'm trying to setup AdvancedFilter to filter out a ListRange of items. After some testing, I realized that it only accepts using a "formula" of <>A when I use a criteria range of 2 cells. If I add a third <>B it just does nothing. My original…
FreeSoftwareServers
  • 1,779
  • 14
  • 33
1
vote
1 answer

Azure EventGrid Advanced Filter where Subject does not contain string

Scenario: EventGrid-triggered Azure Function EventGrid messages created when blobs uploaded to any container within a Storage Account I am successfully limiting EventGrid messages, using Advanced Filters, for the following FileTypes Key:…
ericOnline
  • 547
  • 3
  • 15
1
vote
1 answer

Update advanced filter for a range which has new rows added

I have a worksheet containing a list of criteria in cells A1 to J2. Row 1 is the header. Below i have a a table with all my data items. Cells A8 to J with a dynamic numbre of rows Sheets("D0022").Range("A8:" & Sheets("D0022").Cells(Rows.Count,…
Ingram
  • 622
  • 1
  • 6
  • 27
1
vote
1 answer

Excel - Advanced filter with wildcards

I am trying to filter (DATA > Advanced under "Sort & Filter) a range of fields based on a wildcard + text based on the info I'm finding here: https://www.contextures.com/xladvfilter01.html But when I use the * wildcard, it is returning filtered…
akschoeck
  • 37
  • 6
1
vote
0 answers

Advanced filter set up with asterisk wildcard not recognising the asterisk position

I have an AdvancedFilter and my criteria has an asterisk. This should make it so whatever is in cell D3 (D2 is the header) will return results that end with that cell's value. However, it returns results that contain that cell's value, rather than…
Sam
  • 109
  • 8
1
vote
1 answer

Excel VBA Advanced Filter issue due to blank hyperlink criteria

I'm having a bit of a nightmare trying to set up a VBA code in Excel. I'm successfully able to filter out data based using 1 column on a criteria range that is a list of peoples names, provided I only select the criteria range to the bottom of the…
tweaked9107
  • 11
  • 1
1
2 3 4 5