wildcard

  1. B

    find replace * not wildcard

    I am trying to do a find replace on formulas that include * for multiplication. A lot of cells that have *12, *11, *10, etc. and I want to replace all of these to be *1. When I try to do a find replace of '*12' it replaces everything prior to the *12 since the * is flagged as the wildcard...
  2. M

    2 step search - find results in search result

    Hi forum, I'm new here and I've been having a problem to do a 2 step search. Let me (try to) explain: I've got 2 tables I need to compare Table A (30 records) name, Street, zip, town, Value 1 Table B (50000 records) name, Street, zip, town Step 1 - Compare the following to narrow it down...
  3. T

    Sum several colums using wildcard

    Hi, Awesome forum! I am currently working on a sheet for my small business. It is a chart used to look at current and coming expenses. The final version will look something like this (design will be done later:laugh:): In row 3 I want the sum of all "costs" within that month to be summed...
  4. E

    Conitional Formating

    Hi, I have a huge dataset and I need to apply conditional formatting in a very strange and complex way. The data is a mix of hard coded and calculated prices. I need a formula that will apply formatting only if the cell ends with an 5 in the second decimal place (20.55, 5.05, 42.95, etc.). I've...
  5. D

    Using LEFT to extract text, then applying wildcard to the result to do a COUNTIF

    Hi all, I have the results of a survey which allows people to free-type their answers. I have cleaned the answers up however there are a litany of spelling errors for many of the same words. I need to count the instances of these answers, including the misspelled words. I have a list of the...
  6. M

    Using a Wildcard in a Table COUNTIF

    Hi I'm trying to do a COUNTIF in a table that refers to another table, looking for any cell in the RRAR table that contains the text in the field Agency_Name of another table. The cell in the table is... =COUNTIF(RRAR[RRAR_Issued_To],*[@[Agency_Name]]*) It doesnt work with or without the...
  7. P

    using wildcards in vba

    Hi I have the following path: FileCopy Source:="\\retail\$test\Group \AllAreasExcCO\01-01 UAT.xlsx" How do I use a wildcard here so rather specifying "01-01 UAT.xlsx" it would consider anything that matched "01-01" &."xlsx" TIA
  8. G

    VBA Code to Open Adobe File with Wildcards in String

    HI there, Here is my code: Sub Open_CAReport() Dim FANum As Variant FANum = ActiveWorkbook.ActiveSheet.Range("B2").Value Dim Analytics As String Analytics = "X:\abt\ABTP\Programs\ABTP_Reports\ABTP_Analytics\@2018 Client Analytics_US" Dim effmon As String effmon =...
  9. S

    Using a wildcard asterisk to get a file and unzip it

    Hello guys, I'm completely new to VBA. My task is I have a certain zip file on my Downloads, I should unzip the file. With file name known, I'm able to unzip it but the problem is : I don't know the entire file name ("xxx-065-xxx"). I've tried the code below. It indeed shows me that the file...
  10. C

    Sumif Using Wildcard

    Hi, I'm am trying to perform a sum if on the below data. I want to sum only the numbers that begin with the year 2018 (or what ever selection I chose) so I tried the following but it returns zero? =SUMIF(A1:A8,"2018*",B1:B8) Also tried with 2018 typed in cell G1 =SUMIF(A1:A8,G1&"*",B1:B8)...
  11. G

    Sumproduct using wildcard

    I am attempting to use sumproduct to total how many times certain abbreviated terms show up in a single column. Sometimes there is only one term, other times there are a string of terms separated by a slash (/) mark. The terms are H, MED, DRUG, ALC, OTC, and UNK. For instance one cell might be...
  12. B

    Formula to Replace Wildcard Characters in a String

    So, based on a good amount of previous searching I've almost created a nested formula which does what I need, but I am currently falling at the last fence! Hopefully someone here can help out. I am trying to remove all non-alpha characters from a text string and through a huge nest of...
  13. M

    Wildcard with the workbooks.open function

    Hi there, I am using the wildcard in the filename for the workbooks.open function. In Excel 2013 it works fine, but in Excel 2003 (which we also use) then it does not work. Should this version be a problem? The code I use is: DataWkBkName1 = prodNumberIn & "_ac_rev-?_DTS Inner 12...
  14. R

    SUM/SUMIFS with Conditional Array & Wildcards

    Hello! I'm working with the following section of a formula: SUM(SUMIFS('All Facilities'!$AC:$AC,'All Facilities'!$F:$F,$C$29,'All Facilities'!$AR:$AR,{"Operating","2017*"})) It's working just fine (and yes, entered with ctrl+shift+enter), but I want to make an adjustment to it: That last part...
  15. A

    Find cells that start with a specific text and replace with

    Hi all, I am pretty sure I've been able to use the find and replace function for this before; I have a complete brain freeze. I have a lot of entries on excel; they are urls. Some of them have the root domain included and some don't. for example: www.example.com/product123 /product435...
  16. L

    VBA Loop for Multiple Sheet to Search Wildcard on Master

    I am VERY new to vba and usually use record macro for repetitive functions but can't do so in this case so need some help with coding. My question was deleted from another question site so I'm going to try to do a better job explaining, as I would really love the coding to make this work. I...
  17. X

    VBA AutoFilter HELP!

    Hi :) I'm a complete newbie when it comes to VBA script. I have a file that i want to include some Autofilter data search fields in but am having some trouble with trying to figure out how to make the following script do this: 1. Point script to search in cell A2 but search as a wildcard...
  18. P

    Add a Wildcard to an index

    Hi All, Can I add a wildcard to and index. I have a table of data from which I am calling back pricing from all instances from the given lookup, but it will only pull exact matches but I need it ad a wildcard.. i.e. I need to search for CH12-04268-(any character) but I have to state...
  19. M

    How to create filtered list using formula by criteria containing asterisks

    Dear friends, i will be very glad for your help. Here is my situation: I know how to create such a filtered list using the array formula combining INDEX and SMALL functions but this does not allow me to use criteria containing asterisks. If I used criteria "1,2,3,4,5,6" instead of "1,*,*,*,5,6"...
  20. P

    vba wildcard - FileCopy

    Hi I'm using the FileCopy function to copy files from one location to another. I would like to change slightly so that I can use a wildcard For example: \\homedrivestmp\homedisk1\saery\Desktop\test250118.xlsx Rather than specify the file name as above, I would like to target files where the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top