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...

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...

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...

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...

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

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 =...

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...

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)...

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...

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...

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...

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...

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...

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...

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...

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...

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"...

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...

Hi The following formula works fine: =SUMPRODUCT((Master2!P2:P5000*Master2!X2:X5000)*(Dashboard!B47&A1=Master2!A2:A5000)) However I'd like to add a wildcard as below: =SUMPRODUCT((Master2!P2:P5000*Master2!X2:X5000)*("*"&Dashboard!B47&A1&"*"=Master2!A2:A5000)) Would appreciate any assistance...

I have an Excel list with many websites. Some end in .com, .net, .org. But some end in .com.mx, .fr, .ru. How do I do an advanced filter to remove all .com.mx, .fr, and .ru while keeping all .com, .net, and .org?