How To Represent Numeric Wildcard

Aug 21, 2009

In column A I have a sentence.

I would like column B to return TRUE if the sentence in column A contains any of the string below:

AAA¤
BBB¤
CCC¤
DDD¤
EEE¤
FFF¤
GGG¤
HHH¤
III¤
JJJ¤

Where ¤ is any number from 1 to 9.

Is there a formula to do this, preferably without having to list all the possible combination of the list e.g. AAA1, AAA2, AAA3, and so on?

View 9 Replies


ADVERTISEMENT

Formula To Represent Trendline And R2 Value

Dec 29, 2013

I have created a scatterplot with a trendline and I need a formula to represent the trendline so it can be applied to separate results. How I can create a formula and an R2 value?

View 1 Replies View Related

Bar Graph - Represent Sum Of Two Columns In One Bar

May 7, 2012

I have multiple columns with data and I want to represent them in a bar graph. The problem is that for some of them I want to represent the sum something like:

Columns A and B sum and represent (I don't want to make another column, C, with the sum, the sum of the two columns should be done by the graph).

View 1 Replies View Related

Letters To Represent Numbers

Jun 30, 2008

how to make letter represent numbers what i am trying to do. i am trying to put a sheet together to make my life easyer. i am a lectuer and need to keep trake of studes progress how this is done is that over the year they are graded my Pass Merit Distinction in using offic 2007 (Excel)and i was to make it so that if i put in a P it will =6 points ,M=12 points and D=18 points and for the total points to for each student to come up on the side after the units if there a rule for this and how would i put the rule into the sheet ?

View 3 Replies View Related

What Does Percentage Represent When Dimensioning Variable

Mar 6, 2014

I found the code snippet and I cant remember what it "means".

View 4 Replies View Related

Conditional Sum. Values Represent Numbers

Oct 8, 2007

The following percentages equal these numbers:

100% = 5
93-99% = 3
80-92% = 1
<80% = 0
From F5 to AR5 percentages scores will be inserted for each row.

So percentages scores for the first three entries (F5-H5) should yield the following result:

100% + 95% + 85% = 5 + 3 + 1 = 9

View 3 Replies View Related

Graph / Chart Represent Whether Or Not Cell Has Been Filled

May 14, 2014

I am making a spreadsheet that will be used to track employee time usage. I would like to be able to create a graph of the time throughout the day that shows only whether or not the employee has entered an activity during each particular time slot.

EX: The graph shows the time from 8-10am in 30 minute increments. The employee has entered activities for the time slots from 8-9 and 9:30-10. When the graph is created, I would like to see times 8-9 and 9:30-10 filled (or, charted, or, however I should phrase it) and time 9-9:30 left blank (to represent that no work was done).

View 3 Replies View Related

Represent Number Of Days Into A Scale For Statistics

Sep 30, 2008

I have a scenario where by Column A is date incident opened and Colum B is date incident closed.

And Column C shows the days between them. I got this and its fine. However, how do i
make a table or in any how define it as if the number is 1 - 3 days then it should be A

1-3 days = A
4-6 days = B
7-8 days = C
9 days onwards = D

This is because i need to make a chart and graph of the turn around time and the best is to define into a character alphabet so the chart will show the statistics of how many A, B, C and D But how do i do that.

View 9 Replies View Related

Sums- 52 Tables In One Spreadsheet To Represent 52 Weeks

Feb 4, 2009

I have 52 tables in one spreadsheet to represent 52 weeks and have created another table to sum the weekly data but the sum function doesn't do it because of the amount of cells which need adding.

example: c3, c14, c24, c34, c44, c54 etc...

View 9 Replies View Related

Five Digit Numbers That Represent A Persons Code

Dec 1, 2009

In one column (f5:F100) I have five digit numbers that represent a persons code. I have five groups of codes, they are 10000-15000, 16000-19000, 20000-25000, 26000-29000, and 30000-40000. In another column (Column H) I have an "X" saying the are qualified in something.

I am looking for how to write a statement that says answers this question:

How many people are qualified in the codes between 10000-15000.

Ultimately I am going to take this number and divide it by the total number of people in the group to get a percetage of qualified people in the group.

View 9 Replies View Related

Find Maximum. Some Values Are Represent By Text

Aug 8, 2007

I have a column of values the values can be "T", 0.00 ->any number to the nearest hundredth. I thought I had this problems solved a while back but after having time to do some quality control I found that anytime there is a value of "T" the macro does not work. I have had some great help with this in the past to get as far as I have but I still cannot seems to get it 100%. I have attached a sample file. The result that I would like to see is in the cell BH145 is "16,17,23" without the quotes of course.

When you open the worksheet you will see that the values of concern are precipitation values. These values are rounded to nearest hundredth. When there is a trace of precip however it is recorded as "T" therein lies the problem that I cannot seem to solve.

View 8 Replies View Related

Extracting A Numeric A Specific Numeric String From A Description Cell

Oct 22, 2009

I am trying to do is extract the volume size of products in 'ml'
from 10k plus products from a description field cell.
this description field could also contain the weight of the product in grams
so I cannot just do a search for a numeric string ,
it has to be associated with the milli-litres statement .

is is possible to do a sort of ' *ml ' search and then select and copy to another cell ???

View 9 Replies View Related

Creating Chart To Represent Results On ANOVA Analysis

Oct 12, 2012

I am doing an ANOVA analysis of survey results for a set of products, and would like to present a chart to graphically represent the results.

View 1 Replies View Related

Learn Music Scales And Intervals By Using Numbers And Letters To Represent Notes?

Mar 13, 2014

IF key of C has notes CDEFGABCDEFGABC progression, then notes

1-2-3-4 : 2-3-4-5 : 3-4-5-6 will result in C D E F D E F G E F G A respectively

I want to create note patterns regardless of scale type: Major, minor, modal etc in each of 12 keys. Music software exists but simple EXCEL formulas should be available or easily created.

View 2 Replies View Related

Convert Numeric And Scientific Symbol To Numeric Only

Jun 4, 2014

I have a column of several thousand entries listed as numeric with a scientific symbol eg.

1.4mSv
19.53mSv/1mSv (some have a mix and or alpha/numeric range)

I want to convert them to the numeric value only. I'm extracting to a chart which is not recognising the alpha and throwing the data out. I tried find and replace, trying various options within the 'replace format' tab with no joy.

View 6 Replies View Related

Finding A Non Numeric (or Numeric) Character In A Field

Sep 1, 2008

I have a few thousand products codes (i.e ABCD123BLA08 or SHU267BLA) They are non standardised in length or structure. I wish to pull out everything upto the end of the third numeric digit.( ie ABCD123 and SHU267) I cannot use left as they are all different lengths. Ideally i would serach for a non numeric char after the number then use left up to that point. Search can't do this, FIND can't do this.

Summary
ABCD123BLA08 would be ABCD123
SHU246BLU would be SHU246
I147ORT08-12 would be I147

View 9 Replies View Related

If Statement Numeric Or Alpha Numeric

Jan 12, 2010

I have a column that has cells with values as

19352510
C084111X AA
24253081
A001290U AA
19599291
48413321

I want to write an If Statement is a column next to each entry that denotes two options either Broker or Agent. Where the code is say 19352510 then Broker and where it is say C084111X AA then Agent.

Broker codes will never contain a letter. The Agent code will always start and finish with a letter.

View 9 Replies View Related

Return Value Of Date Using Addition From 2 Columns That Represent Date And Number

Feb 21, 2014

I want to get a return value of date in column C whereas column A represent a date and column B represent a number. Simplest formula in excel is Column C (Feb 26, 2014)= Column A (Feb 21, 2014) + Column B (5). I want it to have in macro code.

View 14 Replies View Related

If Then Using Wildcard

Feb 21, 2009

Have a cell that says something like "123 main street".

I want the cell next to it to = Main if it detects main in the other cell and if not then it should say no. I tried this.

=if(B2="*main","Main","No"

However, it is not working.

View 9 Replies View Related

Wildcard

Jun 7, 2006

I transferring data from the mainframe and some data has ????. I can not replace them with something else because excel think it is wildcard. The reason for this request is I was trying to count the number of cells that has ???? and the count was something different each time. If you want to have fun try it out. It will count ?, ??, ??? but not ????.However my question would be how to change this (????) to some thing like unknown...

For Each rngC In rngJbn
rngC = Trim(rngC)
If rngC.Value <> newvalue And rngC.Value <> "ab-" Then
'MsgBox "****" & rngC & "***"
Résultat = Application.CountIf(Range("C2:C" & Range("C" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible), rngC)

MsgBox rngC & " " & Résultat & " " & i
End If
newvalue = rngC.Value
Next

View 6 Replies View Related

Use The Wildcard In An IF Formula

Nov 13, 2008

Is it possible to use the wildcard in an IF formula? For instance, I have a spreadsheet with text and numbers in the cells, the number of characters varies in the cells so a left, right or mid is out. I want the formula to look to the cell and if any part of the text contains "ABC" then I want to return 1. =IF(C18="*ABC*",1,"") Cell C18 containts the letters ABC in order but my formula is still returning blanks?

View 4 Replies View Related

Hyperlink With Wildcard

Aug 3, 2013

The idea

[Code] .....

Dropdown list
-------------
O11 = "Land" , "Sea"
P11 = "A - H" , "I - O" , P - Z"

Directory = C:MammalsLandA - HDate_120313 - Carnivore - Code_A3622

The list of filenames in the "A-H" folder has different dates and codes, how do I go about fixing wildcard *Carnivore* so that regardless of the date and code, there will be a match.

list of files in A-H folder
------------------------
Date_120313 - Carnivore - Code_A3622
Date_030213 - Herbivore - Code_A2231
Date_051212 - Hybrid - Code_A4431

View 10 Replies View Related

Wildcard In IF Statement

Jun 23, 2014

How to use this wildcard in a IF statement.

[Code] ......

I have a column I'm adding a value to another cell if a piece of text is found in the column I'm looking in. The * is not working at all.

View 2 Replies View Related

Turn Off * As A Wildcard

Aug 28, 2007

The use of * as a wildcard in excel can be extremely useful, however, can it be turned off? I work in the education sector and am currently number crunching GCSE results. When it comes to calculating A* grades versus A grades, B grades, etc, I cannot seem to do it because of the wildcard.

View 12 Replies View Related

Wildcard Incorrect

Dec 7, 2007

I have tried everything I can think of to get this to work.

I am searching column B for anything containing "Tease", then if found, look to see if column J contains a "W".

Excel doesn't report an error, but this doesn't work:

=SUMPRODUCT((B3:B40="*Tease*")*(J3:J40="W"))

View 10 Replies View Related

Formula Wildcard

May 1, 2009

Hi I have this formula:

View 3 Replies View Related

Can Wildcard Be Used In If Statement

Oct 31, 2011

As far as I know, a wildcard can't be used in an "if" statement. I have a list of "job names" that vary slightly from time to time. When we use a Bunnings "(building account) people give a job name such as "121 William Drive". Sometimes however, the person in the store spells it incorrectly. Is there a way to find a wildcard in the following manner?

Find any word that begins with "121" and ends in "ve"

In a1 it says: "121 wilaim jnes drive" I have tried the following formula in b1:

=IF(a1="121*ve","yes","no")

Why does it say "no"? Is there a formula for using wildcards in an "if" statement?

View 2 Replies View Related

VBA Countif With Wildcard

May 15, 2012

Trying to count how many cells in column b contain a value.

using

Application.WorksheetFunction.CountIf(Range("B:B"), "" * "")

getting a type mismatch error.

View 2 Replies View Related

Lookup With Wildcard

Mar 27, 2014

I was wondering is there away where i can lookup A:A anything begging with Ves* ? and then i need to copy the formula down to pick up the next one in the list

im guessing something like =VLOOKUP(A:A,"Ves*") but i havent got a clue

View 1 Replies View Related

SQL WILDCARD In Column NAME

Feb 18, 2009

In a recent thread, I learnt how to import HTML, using ADO into Excel.

To import the relevant variables, my code is as below: ...

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved