wild card

  1. R

    Formatting / adding data to field

    Hi if I have 1108000 1104006 1702003 and I want it to be c:\data\1108000.jpg c:\data\1104006.jpg c:\data\1702003.jpg How can I do this? Thank you.
  2. M

    Return the corresponding row header based text contained in data set.

    I want to return the relative name from column A in cell B16 if the data set = "ORS". I wrote the following formula and it works fine. =@IF(COUNTIF($B$6:$D$13,"ORS")>1,"Check Call Schedule",INDEX($A$6:$A$13,SUMPRODUCT(($B$6:$D$13="ORS")*(ROW($A$6:$A$13)-ROW($A$5))),)) This Issue: However...
  3. P

    VBA loop with wildcard in Sheet name

    Hi All, I'm pretty new to VBA, this is my also my first time posting on here. Hoping somebody can help me tweak my code; The code loops through all the files in a folder to copy data from a sheet called ("P&L 2019 - UK GAAP") into one workbook. The issue that I'm having is that, a couple of...
  4. E

    Countif not counting

    Ok so let me start off by saying that I know that this is a common problem but none of the common solutions I've tried are working. I will do my best to describe the problem and I am willing to email the spreadsheet to anyone who thinks that they would be able to help. About the Spreadsheet...
  5. Small Paul

    Worksheet Download Random Name - Wildcard?

    Hi All Sorry, I have to ask for a bit of help here. I have a daily report downloaded which gives a worksheet name of 'report123456' but the numbers are randomly generated. In order for my subsequent macro to work, I think I need to either: a) change the worksheet name to 'Data' b) have a way...
  6. L

    Filter a pivot table filter with a wild card

    Hello everyone I`m new here and I have no knowledge regarding VBA (none what so ever) so I apologize in advance... I`ve recorded a macro that looks like this: Sub Team() ' ' Team Macro ' ' ActiveSheet.PivotTables("PivotTable1").PivotFields( _ "[Feature...
  7. I

    Excel index search using a wildcard character (“*”)

    I'm trying to use an INDEX search instead of a VLOOKUP because I want to display all associated cells with one String in a cell. For example, if my String is "Bob", I want to be able to search Column B for all instances of "Bob", and then produce all associated values from Column C. This...
  8. T

    vba Autofilter with wildcard has error .Range("A" & .Rows.Count).AutoFilter Field:=1, Criteria1:="<>" & FundingDivFilter & "*", Operator:=xlAnd

    The Objxl is just a reference to Excel in the MSAccess vba application. The Access - SQL Server application takes data back and forth to Excel. Lots of Remote automation FundingDivFilter is a string variable. The Normal filter is well known. One filter will work if there is a wild card (*) '...
  9. S

    Excel Cube formulas - wildcards

    Hi, I am having trouble finding resources on how to use wildcards in Excel Cube formulas. I use rollup coding for my gl accounts to create my financial statements. So I attach a code to my wage accounts like "WAGES-OPERATING" for my operating fund; and "WAGES-CAPITAL" for wages in my capital...
  10. A

    Wildcards in a Index(Match()) formula

    Hi all, i am working on a spreadsheet with one Sheet of raw data and a second sheet that i would like to have search the raw data, find a first name last name match and then return whatever is in a corresponding cell. i orginally used a Vlookup which worked unless there were any of the same...
  11. M

    Wilcard Vlookup or Index Match

    I have created a fantasy golf sheet to track scores of players and assign points automatically. However, I am running into a problem when during the tournament the player starts on the back nine which adds a "*" next to his name. This changes day to day. The first day he may have an "*" but the...
  12. D

    Wild Card Vlookup Table Array

    I've got a column (I:I) that contains a string of text. I need to lookup a shorter string from a different sheet/table within I2. For instance, I2 = 14FS UL Primary 2015-16. My table (A:B) has A = 14FS UL B = Full. I would like the lookup formula in J2 to bring in "Full". I've tried using...
  13. P

    Index Match Wild Card doesn't work

    Hello! This is my first post, largely out of desperation to leave the office by 5! I have a spreadsheet with a customer name along with other columns of data (as in Table 1). There is also a list of customers whose rows I want to delete from the spreadsheet (Table 2). I placed a column into...
  14. R

    Index Match with wild card help

    I'm working on a project which provides two excel files. The first file, File1, contains a list of SKU descriptions under the header "SKU". They are somewhat long, and contain superfluous information. <tbody> SKU(A1) <tbody> M GEL-CUMULUS 14 M GEL-CUMULUS 15 M GEL-CUMULUS 16 BR W...
  15. S

    Matching against multiple fields

    Hi, I’m working with two address databases where Address1 sheet has the following headings: Property number – Column G for the sake of below example formula Additional Text Add-Text2 Name Name2 Suffix Street – Column I Town – Column K Postcode And the other, Address2 sheet has: Property...
  16. K

    excel query with wild card in parameter

    Hi Good morning everyone. Having a tough time passing a parameter value from a cell into the query. The field I am filtering is a string but I can only query based on the first 12 characters. So I have been trying to use "begins with" or with "like" and wild card characters, without any luck...
  17. S

    Wildcard in Vlook

    I have a huge spreadsheet of contact. I am trying to scrub out all the email address that contain an email extensions on my exclusion list. For example @gmail.com and I am trying to use a wildcard character to find all the email address within my table that cannot be contacted. I am unable to...
  18. T

    INDEX MATCH formula in combination with a wildcard

    Hi all, Since it is my first time using Excel in this manner, I am not sure if Excel is even able to do so, but I have to try because if it works, it will save me a lot of time. I have got three columns (of which one in a different workbook, but I assume that will not be a problem) Column A: a...
  19. J

    if statement help

    I'm using the formula below to populate a cell if another cell does not contain any of the following "R", "0" or is Blank. if the cell "sheet2!G11" has any of those in it the formula cell is left Blank. If the cell contains anything else then it populates with what is in cell "sheet2!D11"...
  20. E

    Wild Card VLOOKUP needed

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif][if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/>...

Some videos you may like

This Week's Hot Topics

Top