wildcard

  1. P

    Using a wildcard in Sumprooduct

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

    Advanced Filter with wildcards, Excel 2013

    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?
  3. R

    Last wildcard match in a row and returning columnnumber

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

    Reading cell value from a closed Excel file error

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

    VB string to export data to *.bat

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

    using wildcard in countifs

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

    Use of a Wildcard in A VBA Formula

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

    use wildcard to return multiple items from one lookup value

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

    Using wildcard to find number

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

    Sumifs Wildcard and Left

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

    Using wildcard in VBA

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

    VLOOKUP table_array wildcard

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

    Using Wildcard in formula obtained from different formula's results

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

    Merging text with wildcards into one text line

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

    VBA: Copy a string pattern with wildcards from an array to a new column

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

    VBA: If statment with Wildcards

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

    Wildcard and Nested IF Statements

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

    Search for text at end of string

    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,*"...
  19. R

    Pull the first non blank cell data

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

    Using wildcard in LOOKUPVALUE

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

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