I have done is created an Officer Evaluation Form in Word for my Police Chief and the Scores for the different observations are: N/A, 1, 2, 3, 4 and 5. If for example there are 4 observations and one of the observations is "N/A" for not applicable or not observed and the rest are all 5's I want the formula to ignore the field(s) with the N/A and still come up with an average of 5. The way I have it set up now which is: =AVERAGE(KOW1,KOW2,KOW3,KOW4) it comes up with an average of 3 when I put a N/A in field KOW1 and all 5's in KOW2-KOW4.
I would like to use IF function, to get the answer, if the mark is less than or equal to 20, the answer is AVERAGE, if the mark is between 21 and 25 the asnwer is GOOD, if the mark is between 26 and 30 the asnswe is VERY GOOD, if the mark is above 30 then the asnwer must be EXCELLENT.
I am using Excel 2007, and here is my scenario. I have a spreadsheet with a different sheet for each month of the year. I want certain cells in a month's sheet to mirror or be equal to the same cell in the previous sheet so that if I change the value of a cell in April, the same cell will automatically be changed in May.
An example is that I have a cell with the value of "Comcast". If I want to change that value in April to "Directv", I want it to automatically change in May, too.
Now I know that I can individually program a cell to be equal to a cell in another sheet and it will do exactly what I want. The problem is that I have about 60 cells in each sheet that I want to mirror the same cells in the previous sheet, and I don't want the entire sheet to mirror the previous one. So with 11 months/sheets with cells mirroring the previous sheet, individually programming 660 cells and switching between sheets to do that would take a very long time.
So my question is this. Is there any way to select multiple cells and have them all mirror the same cells on a different sheet without my having to program each cell individually?
I have two sets of data to compare. One is real world data, the other is forecasted data. I have real daily data for every day over about 3 months. The predictions though, there may be 4-6 predictions for ever one real daily value.
What I'd like to do is have a function that looks at Column A's date (real daily value) and Column C's date (predicted data) and if Column C equals Column A, then divide corresponding data in Column B by value in Column D.
On the next tab, I want the cell in D5 to equal A9, D6 to equal B9, D7 to C9, etc.
I can't seem to lock the cell correctly to do this. If I use =A$9 in cell D5 and then copy down in cell D6 I'll get A$9 also, but if I use $A9, in D6 I'll get $A10.
I am confusing of using the equal function in vba, I need to have some cells between sheet1 and sheet to be equal but i cannot just put = sign in the sheet as it may be deleted. Can I have it as VBA code? how to do that and where to put this code, in what event?
I have a spreadsheet with Golf Stats on it, and on my latest import, the lookup stopped working. I am no longer able to look up any of the golfers names.I have attached a portion of the spreadsheet as an example.Lookup Failure.xlsx
Before the data was pulled in 'last name','first name' but is now 'first','last'... so that explains why I have the lookup column in Column A, because it used to convert the last,first format to first,last but that is besides the point. What my real problem is not being able to lookup Column D. As you can see in Cell L4, I tried to test if K4=D4 (Both say Nicolas Colsaerts but Excel does not say they are equal).
I am trying to hide rows if cetain cells in that row equal zero using a button on the page. Each cell has lookup formulas that will return a value. If coulmn B,F & I have a value of zero I want to hide the row. As of right now I am using the following code but I keep getting the following error message runtime error '13': type mismatch
I have a date on one sheet, and what I thought was the same exact date on another sheet. I want to vlookup off the date, however the values aren't the same. i.e. when I check to see if they = I get a false. They're both formated the same, custom date m/d/yyyy h:mm, and when I ran the check to see if one was text (t=(A1)) I get confirmation that they are both non-text!
I have 2 text cells (A1, B1) that appear to be the same, however, when I typed the formula "=if(A1=B1,"Yes","No)" in cell C1 the result is NO! (see attachment)
In the range A1:Y66, for every cell whose formula returns a 0, I want it to delete that cell and shift the cells up.
Here is the code I tried, but nothing happened:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column > 25 Then Exit Sub If Target.Rows > 66 Then Exit Sub If Target.Cells.Count > 1 Then Exit Sub If Target.Value = 0 Then Target.Delete Shift:=xlUp End Sub
Is there a formula or macro that will identify which cells on a spreadsheet containing various dollar values will add up to a predetermined total? I work in Accounts Receivable and sometimes vendors send in payments for several invoices with no instructions as to the application. I want to be able list the available invoice amounts on a spreadsheet, and be able to tell which of the cells add up to the payment amount.
I have three columns: Symbol, Dividend Payment, and Shares.
What formula will look at the shares column and symbol column and say if cells in column C are equal each other & cells in Column A are equal to each other than add all the div payment that correspond with those symbols and shares?
A B C D
1 Symbol Dividend Payment Shares Sum (Formula would go here)
2 SEB .75 23
3 SEB .75 23
(result desired) 1.5 (B2+B3) because (add the dividend where their symbol (A2&A3)and shares (C2&C3)are equal) both conditions have to apply to add div payment
Is there a way to set 2 cells equal, while allowing either one to be manually changed? So if I put in value of 10 for Cell1, Cell1 and and Cell2 will both be equal to 10. Then if I change Cell2 to a value of 20, both cells will be equal to 20.
I'm trying to create a formula where I can compare two cells but accept them as equal is one is plus/minus 0.1.
Example: Cell A1 is 3, Cell A2 is 3.2, I want Cell A3 to turn red (or report "1") Cell A1 is 3, Cell A2 is 3.1, I want Cell A3 to turn green (or report "0")
I have cells that they're values should be equal B6=B11, B7=B12, B8=B13, E6=B14, E7=B15, E8=B16, I want a macro that if the values are not equal then the background should be RED and a pop up message "The values should be equal".
I am trying to check if the dates are equal with multiple if statements! Macro works great if first date is wrong, but if the 2nd or third date is not unequal it does not work anymore.
really tried to do it myself but unfortunately
I added an excelexample
Date in E3 is different (if you type in other date in cell b3 macro does work partially).
The invoice itself simply equals cells from a drop down in the columns to the right hand side. (highlight yellow) What im looking to do is if any of the cells in column I equals - - i would like the cells b16:f16 to hide within the same row from the invoice and if there is something in column I that isn't - - i would like them to reappear.