assuming

Assuming I want to search "He resides at Alaska" How can i find this in a text file even when it is scattered all over in the file. So that if each of these words are found in the text file, it should give me a message box "Yes"

<tbody> rating 5-advanced 4- proficient 3- competent 2-developing 1- learning 0-nonperformer range 96-100 90-95 81-89 76-80 70-75 64-69 earned </tbody> Issue: I am trying to auto-populate a score in the "earned" row in the appropriate column based off a score in a...

I am trying to write a statement with multiple IF's and am coming up short and getting #VALUE response. Here is my current statement, =IF(F140="Y","","NA")*OR(IF(F140="N","Y","NA")) I am assuming that I have something conflicting but am not sure what. Any suggestions?

I was wondering if someone could help me! I want to create a simple chart which will show a range (1 to 5) and then where four different values fall on this range. To complicate things slightly I want to put two boxes at either end of the range in which will be a descriptor of what 1 looks like...

Hi, Does anyone know how to achieve this kind of graph? (assuming the x's are numbers of course) Thanks, Mike

Functionally, this is working and doing what I need: ={SUM(COUNTIF(B:AO,B1:AO1))} It's just really slow because I have 9000 rows and this is being dragged down. It would probably take hours to calculate. I'm assuming it's slow because it's taking empty cells into account as in general, only...

I am new to VBA and currently have the following one set-up: Private Sub Workbook_Open() MsgBox "Notify Customer 90 days prior to deadline" MsgBox "Notify Customer when travel has exceeded 75%" End Sub However, the notifications pops every time I open the worksheet and that is not too...