How To Embedd Harvey Ball (symbol) In A Cell
Jun 11, 2009
I would like to embedd a symbol into a cell. I dont want it to be done by using Fonts. By symbol I mean Harvey Balls (Plan, Do, Check, Act) symbol embedded the same as the "and" (&) symbol. I have seen it done once on a spreadsheet but did not get a copy and I would like to recreate it as a way of visually showing the status of an action item.
View 14 Replies
ADVERTISEMENT
Jan 15, 2009
I am asking for help with the program Crystal Ball. Basically what I need is non repeating assumptions. I have a roughly 10 assumptions and they are all uniform discrete distributions between 1 and 10 but I need to make sure that if assumption 1 chooses say number 3 that no other assumptions chooses that number and thus all the numbers are used for each simulation.
View 9 Replies
View Related
Apr 21, 2014
organising a golf tour for 32 players.playing in teams of 4 (4 Balls) for 4 games of golf and the teams are to be randomly selected such that no player plays in a group with a person he has played with in a previous game. finding it difficult to create a spreadsheet which meets this criteria.
need to build into the spreadsheet the fact that the variable mix of people is constrained by the fact that at least 4 persons have to use a buggy (which will have 2 people in it) and as the tour progresses and courses become physically demanding a number of people (N) for the last 2 rounds may also ask for the use of buggies as well.develop a spreadsheet to make the 4 Ball team selections.
View 2 Replies
View Related
Aug 14, 2012
I am trying to automate a simulation with the crystal ball add-in. Specifically the simulation will go through a set of workbooks in a directory - run the simulation (monte carlo x1000) and extra the "trial values" data in another spreadsheet.
I have tried to find crystal ball documentation but I'm not having any luck.
View 2 Replies
View Related
Mar 8, 2007
Need a formula if there is one to extract from a cell only that data which is to the Right of the symbol > and to the left of the symbol (
View 3 Replies
View Related
Aug 24, 2007
I need to take cells such as the following from A1 down:
Baker, Helen
Brown, Joe
Smith, John
Roberts
Thompson, Karen
White, Daniel
Wright, Lisa
I need to move this to the next column but where there is a cell such as the 4th without a comma it needs to add ", N/A".
Basically it should make "Roberts" from A4 become "Roberts, N/A". I think it needs something to search for a comma and if it's not present to add that to the end.
View 3 Replies
View Related
Nov 7, 2009
Is there a way to define the end of a cell in a find/replace? I.e. I want to find characters like this:
;;[space character][end of cell]
and replace with
[end of cell]
(that is just delete the ;;[space character] bit when it is followed by end of cell)
View 5 Replies
View Related
Oct 19, 2011
I am trying to put a (C) within a cell but it keeps converting to the copyright symbol. How do I amend this so I can just have a C in brackets?
View 2 Replies
View Related
Jun 20, 2009
I simply cannot insert a one eighth symbol in my spreadsheet.. I used to be able to see this in the Insert Symbols grib but now all I get are lots of question market.. if I use
selection.value = ChrW(8569)
the symbol does appear until I select the cell and press return, after which point it turns into a question mark.. I'm sure its something to do with my settings but I can't figure out what.. this is really important for me.
View 9 Replies
View Related
Jun 1, 2007
having a problem with a vlookup when the cell value contains ~
ie. John~Smith
it returns an #NA even when my lookup table has John~Smith in it.
View 9 Replies
View Related
Dec 28, 2012
I have a column ful with numbers and would like to add an h (hour) after every number. I found that it is possible for valuta (dollar sign). Is there a way for random symbols that are not in the valuta list?
View 3 Replies
View Related
Nov 29, 2011
I am trying to add a * at the end of a value in a cell, used to signify a note at the bottom of the page. However, as the cell contains a formula, excel thinks I am adding a multiplication sign instead.
Is there anyway to place a * at the end of the value, to show up in the cell as text? I would prefer not to have to paste the value of the cell and then add the *...
View 3 Replies
View Related
Dec 3, 2006
Cells in Columns A & B (57 rows deep) have a real time data feed and can have values of blank, "H", or "R". The H and R can remain in the cell for any length of time. I would like to have an audible ding go off whenever a new H or R appears in columns A or B. Is there a cell formula that can do this? I think a macro solution would not work, because the workbook has a macro that activates every 10 seconds, so I assume a macro solution would interfere if both macros happen to activate at the same time.
View 9 Replies
View Related
Jan 9, 2009
I need a code for filtering the cell's content.
What i want to filter and delete is all/any text found following after the symbol ">" .
View 9 Replies
View Related
Jan 13, 2012
I'm trying to make a formula but are failing. This is the data:
Cells:
a1= ant-gel
a2= ant - gel
a3 = size 1 - 6
a4 = size 1-6
a5 = book - 5
a6 = book-5
a7 = good book
I want a formula that displays "True" if cell contains a "-" symbol AND the dash symbol is surround on both sides by a number (a space can go between dash and number)
I want the results to go in column B
For example, if a1 contains a dash and dashes are surrounded on both sides by a number, then "TRUE", otherwise "FALSE.
therefore:
b1 = FALSE
b2 = FALSE
b3 = TRUE
b4 = TRUE
b5 = FALSE
b6 = FALSE
b7 = FALSE
View 2 Replies
View Related
May 31, 2013
Column (B) contains two different units, either (ug L-1) or (mg L-1). I have this formula, =IF(B2="(ug L-1)",A2/1000,A2), which copies the value in column A to column C, so for cells that are in (mg L-1) units, it's a direct copy, but for cells that are in (ug L-1) units, it divides the value in A by 1000. However, I can't remember what the formula should be if the cell contains a "<" symbol AND is also in (ug L-1) units.
e.g.
< 0.004(ug L-1)
How can I change that to <0.000004?
View 7 Replies
View Related
Oct 9, 2009
I have a sheet that when printed out, will have 1 or more check boxes (depending on a formula) beside various items. Basically, if in a datafield it shows that there should be 3 boxes beside a line, it will show similar to this (except the O's are check boxes).
Usable 3 times per day. O O O
In the actual symbols list, there are no such symbols. I think there must be another type of symbol available as I use: ►
I grabbed that symbol from another spreadsheet, and I have no idea where it came from. I have wanted a similar arrow that points to the left or up, but I have no idea where to find them. I only know that the spreadsheet accepts a copy/paste of this symbol, and it does not seem to be related to any particular font set.
where I could find a "empty box" symbol, and also tell me where symbols like ► come from.
View 9 Replies
View Related
Aug 19, 2009
I need to use the following symbol (,, ▬ ) to show when my prices went up or down but when I try to use them in the VBA, they are replaced by a ?
I considered using the CHAR function, but its 255 characters do not incorporate the one I need.
View 7 Replies
View Related
May 22, 2008
I have a large list of data.
Approx 10,000 rows.
All I'm looking to do is delete in each row everything after the / symbol.
So everything after a forward slash gets deleted.
All my data is in ColA from A3 downwards.
Ideally would love a macro I can assign a button to.
As an example;
info@123croieres.com/Categories/travel-and-tourism-lodging.htm
So the above after the macro run would look like;
info@123croieres.com
View 9 Replies
View Related
Feb 16, 2009
I'm logging temperatures and I want to add the degree symbol "" to the end of the numbers, how do I do that? It's easy if I just use one number (#), but how do I do it when adding the lowest and highest in the same cell, e.g. 33-35?
View 9 Replies
View Related
Feb 20, 2007
i would like to automate the inserting of the symbol ...
i can do in a cell as the first entry, but i can't do at the end of a string's entry in a cell...?
ActiveCell.FormulaR1C1 = ""
or
ActiveCell.FormulaR1C1 = "Schukas"
View 9 Replies
View Related
Jul 10, 2008
I am trying to create a document and i'm not sure if this is possible or not, but i'd like to type in a number in column A (1-10) and then in column B have a symbol appear corresponding to the number.
So if i type in 5 in Column A, Column B will have 5 squares pop up (or something along those lines), etc.
View 14 Replies
View Related
Oct 19, 2008
I would like to count all fields which contain the symbol checkmark.
In another instance I am using the formula
=COUNTIF(B124:B137,"X") to count all fields
which contain an X.
However I don't know the reference for the symbol checkmark.
View 4 Replies
View Related
May 23, 2013
I am trying to create a custom number format that will put a plus sign in from of the value in a cell if the value is positive.
Here is what I have been using:
+#,###;-#,###;"On Forecast"
There have been a few problems with this. Firstly, the values are have two decimals, and I have not been able to adjust it accordingly. Secondly, there are some cells that contain only a zero, and the custom format above changes the zeros to 'On Forecast. Other than these two issues, that custom format works.
View 1 Replies
View Related
Nov 4, 2013
I am wondering if there is a symbol for "text" that I can use in a formula. I.e., =if(C="text", "", INDEX(C:C,MATCH(D16,A18:A23,0)))
View 4 Replies
View Related
Jul 9, 2014
I'm using a large database - excel based, with lots of VBA and macros inside - where the default decimal format is “.” (period). When I copy and paste into a normal excel workbook format I want to replace the periods with comas. The paste function I'm using is “Match Destination Formatting (M)”.
I've recorded a macro to replace all of the periods with comas - still some of the values come up as a whole number, the period not being replaced with the coma.
I've tried almost all of the formats - text, general, number .... Still does not work.
View 7 Replies
View Related
Jul 15, 2008
I want to show the insert symbol dialog through vba code. How?
View 12 Replies
View Related
Jul 27, 2009
is it possible to take a cell, and add a symbol in between every word?
for example:
cell1 = i am having a good day
desired cell1 becomes = i-am-having-a-good-day
cell2 = super awesome
desired cell2 becomes = super-awesome
i have looked into the option of using Data > Text To Columns, then using = CONCATENATE(B54,"-",C54,"-",D54) to form the string
however, since the different cells have different lengths of words, the concatenate(cell,"-",cell...) is not flexible...
View 2 Replies
View Related
Jan 10, 2010
For copying cell content into an other cell one can use = in the receiving cell.
Is there an equivalent symbol that will only copy the formatting into the receiving cell, without using format painter?
Can complete formatting instructions for each cell be seen somewhere, similar to the data in the formula bar?
View 12 Replies
View Related
Sep 3, 2012
how to add Indian currency symbol before all numbers in my excel worksheet?
View 5 Replies
View Related