1. D

    Finding wildcard match from table row (PDF file import)

    Hi guys! I'm importing PDF-files into Excel in Office365 environment, using PowerQuery's new-ish PDF file support. However, given there are some minor differences over files, PowerQuery / Excel parses data a bit differently, based on individual PDF. I'm counting on the number of imported rows...
  2. A

    Wildcard with numbers in sumif

    Hi all, i want to sum only numbers contain 15 in range. all data are in number format. Example is attached. Thank you very much in advance.
  3. B

    Wildcard solution maybe??

    Each week I have to scan a changing list of names that includes former students. I want to find each student listed. My problem is that the list is outside my control and sometimes students names are presented differently depending on who creates that weekly list. Often Thomas becomes Tom...
  4. D

    Excel VBA AutoFiltering using InputBox to specify the Criteria - *contains*

    Hi Folks, My goal is to be able to filter a column in a dynamic table for strings that contain non-alpha characters like #, $, etc using wildcards (*). I wish to use an InputBox to specify the special character. Something unexpected is happening: If I directly code 'Criteria1' e.g., for #...
  5. N

    Need Help With Wildcard Vlookup

    I have a list of items that I need to be able to use a vlookup to see if it contains a certain string of text. For example I need to use the below items to be able to do a look up based off everything before "-4". I know I could do an =len and then use that to do an =left to get rid of the -4...
  6. E

    Vlookup with "inversed" wildcard

    So I think I generally understand how the "*" wildcard with vlookup works, but I need an "inverse" wildcard. Below is an example of my challenges: I have a list of Responses (column B) (over 2000 responses) that vary significantly but I need to recode it based on the "sample table" For...
  7. B

    VBA SQL Query ACCESS DB w/ LIKE "*" Operator

    Hi Community, Looking for some help in solving a problem. I am getting back a NULL (no records it seems) when processing this query in VBA, but when i try it similarly in Acess it works the way it's supposed to. Not sure what i am doing wrong here. Any help would be appreciated. VBA SQL...
  8. M

    Sum Frequency with Wildcard

    Morning all, I've got a working Sum Frequency formula which counts unique matches. =SUM(--(FREQUENCY(IF((Driver!$A$2:$A$1973='Data Selection'!$A$1)*(Driver!$G$2:$G$1973="No"),MATCH(Driver!$D$2:$D$1973,Driver!$D$2:$D$1973,0)),ROW(Driver!$D$2:$D$1973)-ROW(OFFSET(Driver!$D$1,1,))+1)>0)) It works...
  9. A

    #-Wildcard application

    Hi guys! :) I am interested in finding out the exact version that the loop is coming across in the array. In this case it is v1 for i, though v5 is also possible. For my particular task it is important that I only retrieve the newest one (i.e. v5). In some rare cases there is also no version...
  10. 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...
  11. C

    How to include a string character with wildcard reference to cell - Countif

    I need to include a Comma plus 1 blank space to come before a wildcard reference to a cell content with countif/countifs Here is how the formal looks without the comma and blank ", " added =COUNTIF(ref_name,"*"&$A1&"*") Is this possible?
  12. A

    Search For File In Directory Using Wildcard Works, But Now To Get The Complete Name Of That File

    This code checks to see if a file (tar_str) exists in a directory. Sub cheese() sdate = 43609 'May 24 2019 EDate = 43757 'Oct 20 2019 Days = 148 For lp = sdate To EDate t_mon = Format(lp, "mmm") t_day = Day(lp) t_dayy = Format(lp, "ddd")...
  13. T

    Wildcard for MSQuery not Working

    I want to us * in a drop down list to return all results of a query. This is not working for some reason. The data has "y", "n", and i want to use * to pull all results when I change the drop down selection. Any ideas why? Thanks, Trent
  14. B

    check if folder exist with wildcards

    I would like to use a wildcard to check if a folder exist. i have tried the following: "C:\Users\*\Desktop\New folder" "C:\Users" & "*" & "\Desktop\New folder" "C:\Users\ + "*" + "\Desktop\New folder" i get, "bad file name or number." is there a way to do this? Sub TestForDir()Dim strDir As...
  15. U

    Can I use Excel VBA Dialog box to display files starting Day*.xml so that my user can choose file to open

    In Excel, the following VBA code does not work properly. dlgAnswer = Application.Dialogs(xlDialogOpen).Show("day*.xls") It opens the Dialog Box but shows all files in the folder (including day*.xls). I was expecting it to show only the files starting with filename as day* . I tried Fileopen...
  16. H


    I am performing an if formula that has 2 AND criteria, fo which one is a contains wildcard. I read that countifs may be the solution but I am still off the mark Can anyone help please? Many thanks
  17. W

    Help using INDEX MATCH with Wildcards

    Hello, I am currently trying to clean up contact information at my firm. The goal is to search client names on sheet A [e.g. Waltham City of (MA)] for state abbreviations in parenthesis. If an abbreviation exists, match this to state abbreviations in parenthesis listed on sheet B and pull (via...
  18. A

    Vlookup Loop Wildcard - VBA

    Hello, This is a part of the code that i have written, and what i wanted to do is to add a wildcard at the lookup value like in a common formula for instance : =VLOOKUP("*"&C1&"*";A1:B2;2). I need to apply the asterists at the beginning and at the end in the code. Range("E2").Select For i =...
  19. A

    Nested IF formula with wildcard

    I am setting up a spreadsheet to collect monthly figures. Of these figures I want excel to automatically calculate a percentage using two figures. I have this formula just fine. I want to have the formula present for all future months so that when I input the figures it automatically calculates...
  20. C

    Wildcard in IF statement

    Hey there, I know you cant really put a wildcard in a if statement but does anyone have any suggestions to get this formula to work? =IFERROR(INDEX(Number; MATCH(0; COUNTIF(F$14:$F14;Number)+IF(Priority<>$C$3; 1; 0)+IF(SelectedCustomer<>Customer; 1; 0); 0)); "") I want the selectedcustomer to...

Watch MrExcel Video

This Week's Hot Topics

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 MrExcel.com.
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 "mrexcel.com".
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