wildcards

  1. T

    using wildcards for text in index/match multiple criteria in Excel

    I'm having trouble using wildcards for text in index/match multiple criteria; I need to find the nearest site along a river (x) below a certain point (distance =21), each stretch of the river is labelled with the streches downstream (so stretch abc is upstream of ab). My problem arises when the...
  2. C

    Issue with Advanved Filter Wildcard! please help!

    Hi all, I am working on my advanced filter. I would like to find all date records that contain 2014. The issue is that some records contain Q1 2014, Q2 2014, etc and others have 2014 strictly as date. If i type in "2014" in the crteria ecxel will return all 2014 records BUT NOT q1 2014 nor q2...
  3. S

    Looking for index match type formula using two wildcard references into a column

    Basically I have 3 columns of data. A and B have single part numbers, C has kits with these part numbers and other data. I am looking for a formula that will let me search with wildcards in all of column C for a kit that has both parts A and B and return the kit number to column D. C's kit...
  4. J

    If another cell contains just any two characters then make this cell equal...

    Hi, I know this should be easy... TIA... I'm in cell c2… if cell c3 contains just any two characters only (a-z or 0-9) then make this cell equal "." (just a period [or any char I choose]), otherwise just leave cell c2 blank.
  5. L

    Looking for a wildcard in a SUMPRODUCT function

    Good Afternoon! So - I have two columns of data. Column F contains a regions (Africa, Middle East, Europe or UK) and column G contains a month and date range of an event occuring within that region, hoever not all cells in column G contain data. I would like to create a formula that will count...
  6. M

    Wildcards nested within LARGE or SMALL and IF functions.

    Hello all, First post here as I have finally run out of places to search. I am using a formula to lookup the largest (or kth largest/smallest) value on another sheet {these are entered as arrays}: =INDEX(SHEET1!$H$2:$H$827, LARGE(IF($C1=SHEET1!$G$2:$G$827...
  7. A

    IF VLOOKUP + partial text match...wildcards or index match?!

    Hi everybody-I'm stuck and need some help here. I'm trying to write a function that looks for an ID # on another page (EXPORT) and pulls a designated value (XXL) IF it finds a partial text match (XXL) within text that will read "Custom XXL - Protein Powders" + a few other variations that all...
  8. D

    VBA filter columns by values and wildcards

    Hello All, For a table that i have I use below code to filter based on column titels. Showing only columns that meat the criteria in row 8. However this currently only works for an exact match (I already managed to get around the case sensitivity). I would need a code that filters for part of...
  9. C

    IF Statement HELP!?

    I hope that one of your Excel Geniuses can help me out with this. I have a master product file spreadsheet. When I exported from my Content Management System into a CSV file it created one column to designate the categories each product has assigned to it. For example, "Product A" falls...
  10. L

    IF and Wildcards

    I've done lots of searching online and on this board and I am still unable to get the solutions that I've found to do what I want them to do. I need a statement that will compare two cells and see if they match. However, one of the cells will contain the "Maker" and the "Model Number". The...
  11. J

    "*" in Formula but not as Wildcard

    I have some data in a column that I need to do a VLOOKUP on and the data contains an "*" Example "*AFF" and I need to find a way that I can find the exact match in another spreadsheet for "*AFF" without it using this "*" as a wildcard and returning "NBAFF" instead of "#N/A" when the value is not...
  12. F

    Find & Replace with wildcards returning original text

    I want to be able to part of string that was found with wild cards, but maintain the values that the wild cards replaced. I have data that may contain strings of the following form xxx, [abcd, efgh], xxx I want to be able to replace this with the following string xxx, [abcd/efgh], xxx...
  13. J

    Wild Card help

    Version: 2007 Need to find a replace the following: Find '=+' Replace =+' It is not finding the formula (written as text). I am trying to replace the single quote with nothing so it becomes a formula again. I thought the tilda placed before it would help find it but that didnt' work. Of...
  14. R

    Can VBA find a "?" in a row?

    I'm trying to find any cells in my table that have the entry "???" but sadly VBA is just reading the ?s as wildcards. Is there any way to make it specifically find the characters? Thank you!
  15. B

    Wildcarding cell references

    I want a cell to be able to check each cell on row 1 using IF and if a specific value is present to COUNT/COUNTIF all cells from *3:*151 (where * denoted the coloumn of the cell checked) Is wildcarding cell coloumns/rows possible? :confused: I hope I've explained this correctly. Thanks
  16. A

    2 conditions and one wildcard in a phrase

    "I want to find 'Mozilla' in the phrase in column 'A' and 'Phone' in column 'B': A B BW System 20042010 Phone Screen no bright on laptop Phone Pop up screen in Mozilla...
  17. S

    sumproduct w/ wild card question

    I am having trouble getting the wild card "*" to work with SUMPRODUCT. For instance, I want to count the number of cells within a range of employee names where the name/text contains the "word" TBD (among other conditions). Lets say Column A is employee names, Column B is the employee's...
  18. D

    SUM PRODUCT and Return Multiple Items From One Lookup Value for Table

    Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I used the video <o:p></o:p> "Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table" to create a great lookup devise. <o:p></o:p> <o:p></o:p> I would like to set up another...
  19. L

    Conditional format if value contains *Text* (with wildcards)

    Hello. I'm trying to set up a conditional format so my cells will be filled if the value includes a specific text string, but I need to use wildcards before and after the specific text string. In other words, if the cell value contains the text "my specific text", anywhere in the cell value, I...
  20. R

    Find/replace > change to red

    Hi, We have exported our database to Excel and we need to change th ecolour of our variables to red: We have cells like this: The property offers ${BusinessAmty}. This property has ${RecFacilities}, ${RecFacilities}, and ${RecFacilities}. How do I change all the different ${*} to red. I know...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top