Summary: I have a 10 step process for creating classes (10 columns). As each step is completed, an "X" is placed in the spreadsheet cell. How do I assign a 10%...
Summary: I have two columns of information. Column A represents original customer names and Column B represents new/updated customer names. I need a formula ...
Summary: Hi I'm trying to work out how to devise a formula in Excel 2003 which does the following ... Searches a range of cells for a certain text value 'False...
Summary: i need to give letters a value for a shift rota, eg i need "N" to equal 11 and "LD" to equal 12. Each cell will have N or LD for different shifts, the...
Summary: I want to be able to return the lowest text value between a range of cells but am unable to work it out all help seems to only do this with numbers. e...
Summary: Hi there, I'm a bit new to VBA in Word. I have a userform that currently asks for a text string (a name) and then drops it into the document at a part...
Summary: How can I do this in Excel? I have 2 cells: A1="Bob", B1="Bob, Joe" or it could be: A1="Bob", B1="Joe" or A1="", B1="Joe" or A1="Joe", B1="" etc. I wa...
Summary: Well, a couple of thoughts. One, I think you should re-evaluate the structure of your table. Instead of looking in the "name" column to determine if a...
Summary: I have a spreadsheet with 42 (A thru AP) columns of text values. Some values appears in all 42 columns, while most appear in some, but not all. Is ...
Summary: In essence, they are. An input of 4 for a 15 weight is not as "important" as an input of 4 for a 20 weight - 12 vs 16 in the final calculation. The o...
Summary: Alrighty, I found the issue. Since the routine is a Change routine any change in the worksheet triggers this routine. Hence when I assign a value to a...
Summary: Use conditional formating. You can assign any value you want. So if the value is <100, the number changes to the color blue or something. Larry "Ha...
Summary: Left(A1,4) is actually a text function and produces a text value '1234'. If you are using it in a lookup function and the lookup column contains numer...
Summary: I have tested this function and is working fine: Private Function Get_Count() As Integer Dim TempSet As DAO.Recordset ' The results to return My_SQL =...
Summary: I beg to differ. I'm no Word wizard, but here is what I just did: I created a Word document by simply opening Word, entering some text and saving it ...
Summary: Maybe I need to make myself clear... I want a text value in one sheet which is automatically copied to a "summary" sheet to have a background color of...
Summary: I am trying to assign a value to letters (Y,N). In some columns I need Y to equal "10 and others I need it to equal "3". Same with N. When all "Y's" a...
Summary: I'll give the Select Case a try sometime soon, for fun. For now the IF..Then statement works well. I have another issue I discovered. After I chan...
Summary: ah then you could use =TEXT(VALUE(A2),"0%") for your extra column but I'll have a look into mergeformats, I'm sure I had to do it for a colleague a c...
Summary: Bec_Wik The key point of Humar's response is that "TRUE" with the quotes places a text value in the cell while TRUE without the quotes places a logic...
Summary: To make sure that all of your values are numbers, try this: Click on any empty cell. Do an Edit...Copy. Highlight your list of values. Edit...PasteSpe...
Summary: Just a few tips... 1 - This is not "conditional formatting". Conditional Formatting is a specific feature found under the Format menu that will allows...
Summary: The point here is that all formulae used for Conditional Formatting must evaluate to either TRUE or FALSE. When Excel evaluates the formula to TRUE, i...
Summary: also note if you're looking up dates and using the "&" separator, you need to use TEXT(value that returns a date, "d/m/yy") Put this around your look...
Summary: Hi, I couldn't think of a way to do all of this with formulas. Maintaining a list of unique referent names on the referent worksheet seems to require...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
