wildcard

  1. 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?
  2. 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")...
  3. 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
  4. 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...
  5. 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...
  6. H

    IF AND and WILDCARDS

    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
  7. 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...
  8. 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 =...
  9. 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...
  10. 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...
  11. M

    Lookup on specific text in a cell to return value in another cell

    Hi, I have an issue whereby I download data each month and the text in these cells changes slightly each time so it’s not possible to use a standard vlookup. What I would like to do is lookup specific text in one cell to return a value in another. For example the following is in these cells...
  12. S

    index match wildcard multiple search across a table

    Hello - I've been searching the boards and the web. I can't seem to get the logic and put things together. I can't find the thread or a web page. Perhaps I'm searching the wrong terminology. I want to have partial/wildcard search capabilities. I know I'm making this more complicated than I...
  13. K

    NOT LIKE query in Access 2013 not working

    I work in MS Access almost exclusively in Design View because I have to do quick little queries often and it is fast and easy. With that caveat, I would prefer to have a solution in Design View if at all possible. I am trying to combine wildcard queries that are both "Like" and "Not Like". When...
  14. L

    INDEX/MATCH with wildcard

    So, I have a list of employee names that I'm matching a plan type (there are multiple plans per employee) and having it return a value. My issue is that the value from the sheet that the information is on will sometimes have a space at the end of the employee name. I've been trying to use a...
  15. L

    Wildcard If Statment

    I'm struggling to use a wildcard with an if statement. my formula is "=IF(OR(BZ1="99",BZ1="99"&"*"),"True","False")" I need it to check the cell and if it has either 99 or variations of 99- then be true.
  16. P

    lookup with wildcard

    Hi, Assuming these are 2 seperate lists in different tabs I would like to return the value in the second column as it is the closest match. Is this possible? If I wanted to return the first column i would use vlookup("*"&a1.... <tbody> Rehab Support Worker Support Worker Assistant...
  17. C

    Astericks / Wildcard Use

    I have an issue where my company got into the habit year's ago of denoting discontinued product with an astericks in our product description field. Management do not want this changed. This is an issue for me. Is there a way where I can use the astericks in a formula where only an astericks...
  18. Z

    How to open a workbook with a variable date

    Hi, All... I am trying to write code that will open a spreadsheet so it can be used for a series of vlookup formulas, but the file name has a date in it that changes as updates are made. I am pretty sure the solution is just to use a wildcard for the date piece of the file name, but I've never...
  19. P

    SUMIFS multiple criteria including number "starts with"

    Having a problem getting this sumifs formula to work correctly using a wild card. Sum Range: Col I Criteria Range 1: Col C Criteria 1: Starts with "10" (there is a 6 digit number - not a number stored as text, 1st 2 digits should be 1 and 0) Criteria Range 2: Col N Criteria 2: = C$1...
  20. X

    Replacing Wildcard Text in Find/Replace

    Is there away to “move” the info that’s captured with the * wildcard character when you’re using Find & Replace? For example: I’m looking at a sheet with the following in Column A 1 Public Records of Baltimore County, State of Maryland 2 Public Records of Cuyahoga County, State of...

Some videos you may like

This Week's Hot Topics

Top