wildcards

I have a data set of values that is grouped into 6 buckets (Tier). I am using Countifs to generate a histogram of the values for each bucket (=COUNTIFS(MinCoverage!$H:$H,">"&$A7,MinCoverage!H:H,"<"&$A8,MinCoverage!$E:$E,Tier)). The histogram works great for each bucket/Tier. However, I also want...

I am filtering a list of 400 text strings ( I have posted a subset below), some of which have anywhere from 1 to 4 asterisks. I know how to use the ~ to filter (both advanced filter and auto filter) for ANY number of asterisks: *~*. I also know how to use the ~ to advanced filter for more than...

I've tried to modify the following formula to use wildcards but I can't seem to figure it out. =IF(ISERROR(INDEX($B$1:$C$1000,SMALL(IF($C$1:$C$1000=$D$1,ROW($C$1:$C$1000)),ROW(1:1)),1)),"",INDEX($B$1:$C$1000,SMALL(IF($C$1:$C$1000=$D$1,ROW($C$1:$C$1000)),ROW(1:1)),1)) I'm trying to get the...

Vlookup, Match by Date with Wildcards! Hi all, first time posting a new thread and hoping for any help!! I'm trying to do a vlookup/match with wildcard, except that my lookup_value is a date, i.e. 12/18/2013, and my lookup_array is more in the form of "Cash Distribution - 12/18/2013" where...

Is there anyway to make Excel interpret 'A*' as 'an A followed by a star' rather than 'any string beginning with an A'? Thanks in advance. I apologise if this has already been asked. I've searched but didn't find anything. If you are wondering why I want to know... I am a teacher in the UK...

I have a bunch of formulas on a sheet of the form: =whole_buncha_stuff, ROUND(SUM(whole_buncha_otherstuff),1),more_other_stuff) I want to remove the ROUND() function: =whole_buncha_stuff, SUM(whole_buncha_otherstuff),more_other_stuff) where the "whole_buncha...." strings represent variable...

Hi. There are two questions inherent to this thread. But let's go step-wise: I have this formula in which I want to sum items (Description) that contains ANY of the strings in the C16 to C17 range: = SUMPRODUCT( SUMIFS(Value; Description; "*"& C16:C17 &"*") ) This formula however, double...

I have tried various types of searches to get the help I need, but it either doesn't exist or, more likely, I am not using the correct language to search. I'm not sure this is something that can be done with a formula. I'm not opposed to VBA, but prefer a formula. Essentially I feel like I need...

Hello all, I'm certain this is out there somewhere, but I've done a lot of searching and can't seem to find a solution for this VLOOKUP question. Although, there's also a strong possibility that I'm misunderstanding the available information... I'm trying to do a VLOOKUP using a specific...

I want to know whether a string is Like "#???" or Like "##??" But the question marks here need to be text only. I am only looking for a number followed by three non-numeric characters (i.e. text) or two numbers, followed by two non-numeric characters. How can I achieve this? Right now Excel is...

Hello, I've made some macros that use wildcards (Like + string) and work perfectly on a worksheet. I'd like to know if it is possible to use the same (or similar) wildcard when searching for a file to automatically open it. Something like this Workbooks.Open directory & Like "filename.xlsx"...

My lookup range consists of a table of chemicals. Below will consist of entirely examples (not real data): [SHEET 2] LOOKUP RANGE: named Table1 CHEMICAL SCORE chemicalA 46 chemicalB 55 Chemicalc 45 ChemicalD 45 [SHEET 1] My lookup value might sometimes have an extra space...

Hello I can find thread explaining how to use wildcard characters with IF using COUNTIF but I am trying to find something that will search multiple columns to say "Y" or "N" if it is contained in either cell. =IF((OR(A1="dealing", AB1="dealing")), "Y", "N") The above formula would do this if...

Hi, I have a range say A1:A100 that is populated with Client Names. I would like to use Advance Filter to copy unique values of Client Names to another Range ... say G1 and in another case H1. This is the criteria I have been testing for a while with no success: in Range B2, my criteria...

I have an old macro that lets me do an advanced filter on a table orginating in SQL. Because of a change in the values in the field i need to use wildcards. Before i had values like below Category SmG SmG/LTM SmG/Trade This was handlet with a filter that gave me all those with: Category SmG...

Hi all, I´m frustrated that you kind people tries so many time to explain functions but still I do not quite get it to work. =SUMPRODUCT(ISNUMBER(SEARCH("[P1";G4:G842))*(SUBTOTAL(109;F4:F842))) I'm trying to find starting text "[P1" from column G4:G842 and from that result/filtered sum the...

So I have an excel sheet with a bunch of responses to a survey, with each question as a heading of a column with the first column being the date the survey was taken and the second column being the time. Each respondent's answers are a row and the very first row of the sheet is blank. So column...

I assumed that the following statement would recognize any text (either numbers or letters) and have the return of "1" or "0" for true or false respectively. Statement: =IF(A1="*",1,0) and I have tired =IF(A1=*,1,0) Niether have worked <tbody> Text 1 [blank] 0 </tbody>

Hi All, First time, long time here and looking for a little specialized help. I am looking to do a cross system data validation template and each have unique and very different account codes that I need to cross reference. The biggest issue I am running into is that there is at least one...

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