wildcards

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

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

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

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.

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

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

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

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

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

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

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

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

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

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!

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

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

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

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

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

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