wildcard

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?

Hello everyone, I've spend weeks trying to find a solution on the internet for my spreadsheet. Usually I can find a solution or work something out, but this time I'm really stuck. It's also embarrissing to ask, because I have the feeling it's simple but I don't/can't see the solution. Here is...

Hello Everyone, I have a workbook where i want to collect numeric data from another excel files (from only 1 cell) without opening them manually. I found a neat macro for this, but something is still not okay and i would like to ask for some help. In the main excel i have a unique string in...

Hey Mr.Excel experts, I'm in need of some assistance here, In order to locate and copy over 1000+ Pdf files I'm trying to create a simple set of strings to apply a wildcard value to a specific column so that each of the entries contains a numerical value (which I already have) and here's the...

hello I have this formula that I use to determine if I can 'kill' a row if it meets the 4 criteria's in a different tab called kill_list. it works fine, but if I try to apply a wildcard in column B of the kill_list the formula fails. It wants a numeric value in order for it to work what is the...

I have this line of code ... .Range("D1").Formula = "=if(C1="""",0,if(C1=""OFF*"",0, if(c1=""STAT"",7.5,(C1-B1)*24-0.5)))" If worked fine when I was simply comparing for the term "OFF", but I have since needed to adapt it for anything beginning with "OFF". I assume a wildcard '*' will not...

I have a large dataset, rows and columns. Column 1 (name), column 2 (another name), column 3 (email). I have a single lookup that spans the 2 "name" columns, and returns the 3 matching columns. Currently it works but you have to plug in the exact name to get a return. Here is the formula...

I am trying to find the total amount of times a number appears if the first digit is the same. I keep getting 0 or #VALUE. From a list, I only care about counting the first digit Example: A1: 1.2.3 A2: 1.3.4 A3: 2.3.4 A4: 2.5.8 A5: 2.2.2 A6: 3.4.7 So, how many times is 1 the first digit...

Hello Everyone. I'm trying to sum values for a given account. In this example the cell (B25) is "723*". The formula should sum all of those that start with 723, but i cannot keep the wildcard working. =sumifs(Dados!$P$2:$P$300000,Dados!$E$2:$E$300000,left($B25,len($B25)-1)*1&"*") I know about...

I want to use the * wildcard in my VBA formula below For Each ws In WorksheetsIf ws.Name Like Worksheets("CtrlPnl").Range("*G2").Value Then ws.Visible = True however keep getting Run-time Error '1004' Please help

Using VLOOKUP, I'm comparing 2 sheets to check if the host is monitored. I extracted the list of guests in sheet1 and the list of hosts in sheet2 Sheet1 A1 Win-2K8-dev1 (335d5188-2e63-44cc-978a-51ea4c90e24c) Win-2K8-mail1 (345d5188-2w64-47cf-973n-53ef459he2rx) .. . Sheet2 A1 Win-2K8-dev1...

Hello, I have searched everyone online and cannot find the solution to what I believe is a simple question. Here is a simple version of what I am trying to accomplish. Sum if the value equals a vlookup. There are four possible outcomes. Option 1, Option 2, Option 3 or All of the above (the...

Hey Everyone, I hope you can help, I haven't been able to find an answer to my question elsewhere. I am looking for a way to combine text with Wildcards or special Characters (%) into one value. For example I have 10 lines of text: <tbody> ******1*****EA*P </tbody>...

Hi, I am stuck on this one so any help is more than welcome :D I have a column with text and I need to copy any account numbers to a new column. The account numbers vary so I have to use wildcards, but the other problem is that the account numbers can have 3 different patterns (hyphen (example...

Hi everyone. I have been having problems getting wildcards to work in an If statment with a built in InStr function. Someone know how to get this to work? If InStr(Cells(row, 1), "_???_") > 0 Then GoTo NotConform End If Thanks

In Excel 2013, I'm trying to create a nested IF statement using wildcards. I have data similar to the following: PC Unit Account CMCPX 21002400 GOOD CMOPX 21002400 BAD CMOPX 70021160 GOOD CMCPX 70021178 BAD CMOPX 70021186 GOOD CMCPX 21001599 GOOD CMOPX 21003601 BAD When "PC Unit" = "CMCPX"...

Currently I am working on pulling out the max values based off criteria. However, the array where there =Max(if(iserror(search( array function is search can contain a variety of formats. Say I want to look up "KD100". I would want to pull back 3 instances: "KD100" by itself "*KD100,*"...

Hi,I am using an array formula to pull up the first non-blank cell data using this formula =INDEX('Raw Data'!MB2:MB1048576,MATCH(FALSE,ISBLANK(MB2:MB1048576),0)), however I need this to be add onto merged cells and its not working, Excel 2010 does not allow array formulas in a merged cell, I...

Hi guys, first post here, I've been working on a problem for a couple of days in PowerPivot. I want a new column to lookup for a match between some text contained in a string and a lookup table, and to return column 2 of the lookup table. Acutal table <tbody> Lookup column Calculated column...