I could make up a little excel spreedsheet to do the scoring for the little aths. Works out, long time since Ive used Exeal and I have forgotten a lot of it.
1st Problem: If k15 equals "green" and also L15 equals "08" then display "8", if not then display nill. I tried: =IF(K15="GREEN" AND L15="08" ,"1","")
2nd: If C15 equals the same as L15 then display "OK" if not, then display "X". If you need anymore information, I'm happy to provide.
I have tried a range of "sumproduct" and "count if" and I am still not having any luck.
What I would like excel to do is to count what surgery/hospital (B)is referring for what product (F)
help.xlsx
I'd like to find out the formula where numerical valued between 1-2000 equals True and numerical under 0 equals False. Examples are in the attachment.
View 3 Replies View Relatedif colum A has a number and colum b say breakfast, lunch, or dunner how do i get colum c to add the numbers in colum A for all the breakfasts
View 10 Replies View RelatedI have a sheet where there is a column showing all the totals of previous entries, however a couple of the cells shouldn't total but just show the last entry.
The cell is for an ongoing count of year to date applications received.
Can anyone tell me a formula that would look for the last data entered in a row and return that value
how to hide a row if a value in a cell equals zero?
View 9 Replies View RelatedWhy a formula would not automatically update? Possible problem is in relation to "<=" component of formulas'.
NOTE: This is not in relation to calculations option being set to 'Manual'.
This problem only effect two cells on my entire workbook and all other cells within the column affected, with the exact same formula, work fine.
The "<=" part of the formula is in relation to a drop down list with values from 1 to 12 and the formula works fine initially when flicking between the dropdown list numbers. But if I save the workbook on dropdown list number 2, the formula no longer works...
I have two columns, Column A which is a list of numbers and Column B which is a list of different sports. What i want is a formula that adds all the values in column A where the adjacent cell in column B equals a given sport (i will use Golf in this example).
View 2 Replies View RelatedI have a column of numbers that after each sum there will be a subtotal. If the sum is a negative number then the new subtotal will be 0. Attached is a sample.
View 3 Replies View RelatedIm using this to loop through ID's for my code.
Sub Test2()
' Select cell A2, *first line of data*.
Range("A2").Select
' Set Do loop to stop when an empty cell is reached.
Do Until IsEmpty(ActiveCell)
' Insert your code here.
' Step down 1 row from present location.
ActiveCell.Offset(1, 0).Select
Loop
End Sub
How can I set a cell value = to what cell I the loop is currently on?
I have a line graph which plots the PERCENT_YIELD of units built (UNITS_PASSED / UNITS_BUILT) every week. I want to fill all future week cells with a formula so dragging the formula is not a manual operation every week (my overall goal is to automate a complex spreadsheet and charts as much as possible).
The formula is =IF(Q1080,Q109/Q108,)
Where Q108 is UNITS_BUILT
Where Q109 is UNITS_PASSED
My theory is if units were built (Q108 not equal to zero), plot the ratio. If no units were built (Q108 is zero) I do not want to plot any value on the chart.
The chart plots the correct values for the True conditions; however the chart plots a zero value for the False conditions. How do I not plot a zero for a false condition?
I have a formula =IF(D87=0,"",E87(D87-E87)/ABS(E87)) that returns a blank if D87 is Zero. if D87 and/or E87 is also Zero how would the formula look?
View 2 Replies View RelatedI have sheets that return their name with the following formula:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
All good, but on my summary sheet (that is summarising the data in each sheet) I want a cell to return me the name that each sheet is called, but simply saying ='SheetName'!B1 is not working
So how to I get the cell on my summary page to return me the text of the cell that is using the above formula.
I'm trying to verify if a cellvalue is available in an array. Here is the code:
First I tried to check if the cellval is in the array by returning a -1, 0 or 1:
Code:
If UBound(txt, cellval) = 0 Then
-> returns zero for value "h3", but also for value "3"
(where cellval the value in the cell is)
(with txt being the array containing "h3,r8,ty657", etc)
But I need only the If to be true when there is an exact match.
I have created a file in which other users use on a daily basis to input their time in and time out hours per activity. There are 16 rows allowing them to input up to 16 activities completed in a day. More often than not they do not use all 16 rows. My issue is that these users are very computer illiterate and will often delete the zero that is in their time in or time out hours on unused rows. This results in their total time displaying "####" I have explained to each of them multiple times to input a zero and their problems will be corrected, but they can't seem to grasp that concept.
How to allow the users to input their times, but if they hit delete on a cell and the cell is blank for it to automatically populate the cell with a zero no matter what the user does. I have all other cells with formulas on the sheet locked, but if I lock these cells then they can't input their times.
I have a round formula,
=round(D65-E65,4)
The issue with this formula is if D65 is 0...then the result is a negative number. Just for clarity,
D65=0, E65=10%.....
So I end up with -10%. I can't have a negative number so I'm looking if the result is negative then the cell just equals 0. Is this possible with an IF formula?
I'm trying to input a check into my macro. Basically the logic I'm trying to follow is:
If Row 1 = Row 2 then delete row 2,
ElseIf Row 1 Row 2 then Display MsgBox "Row 1 and Row 2 are different. Do you wish to continue?"
If user selects yes, resume
If user selects no, end sub and display MsgBox "Macro ended. Please correct changes manually"
I am familiar with the macro DeleteRowOnCell, but I want to delete rows when a cell in a selected column has a formulae which is returning empty text. I tried the macro DeleteRowsFastest without success.
View 2 Replies View RelatedIs it possible to run a macro from an excel cell formula?
ie.
=IF(A1=1, RUN MACRO, 0)
Column B has values 1 2 or 3
I don't care about 2 or 3
If Cell B2=1 and cell C2 is blank, return the word "Fix"
If C2 has a value, leave blank
If B2= 2 or 3, leave blank
Then, as I "fix" these guys, it involvse inserting or deleting cells. which seems to screw up the formula
I have a list of groundwater level values in 800 different wells that were measured in April and October of each year from 1982-present. The problem is that they are listed in order:
Date ELV
04/16/1981120.37
09/17/1981119.25
04/10/1982120.52
10/10/1982118.1
04/10/1983124.36
10/10/1983120.43
etc....
I want a formula that will average all the April values and another one that will average all the October values.
I am trying to insert a row every time a certain value appears in row.
Example attached.Example 1.xlsm
I need to copy the entire row that has the value 2 in column B and insert it in the line above (not fussy). It must be inserted and move all data in other rows accordingly.
I want to format cell A5 so as to where if I put in one of several keywords into it, cell A7 puts several letters (with spaces)
example A6:Normal = A7:AA AA AA Ive got about 10 select words so just one example would be awsome! 07 excel BTW
I am looking for a formula to allow an image file to show when a cell equals a certain text string. If it can be done can it be achieved with multiple images? I am making a database that will calculate from many variables my required glass sizes, given the size and window type and I was hoping to go one step further by making it raise a purchase order from a series of images and other related data.
View 14 Replies View RelatedIs there any way of playing a sound (or even better, speech) whenever a specific cell equals a certain value or contains a certain string (such as "Alarm")? This has to happen automatically as the cell updates and require no interaction.
View 3 Replies View RelatedABaccountamount60000-502,503.4060000-601,143.4860000-70847.7260000-80282.1860000-85238
.1870000-50156.8560000-89200.0080000-80300.0090000-70400.0070000-6020.00
i need formula that will sum column "B" if the last two digits of column "A" = 50,60 or 70.
I have a spreadsheet with a lot of account numbers. I want my Macro to highlight the row A:C if certain accounts are found in the spreadsheet.
For Example:
Account numbers "10998-0000" and "18999-0000" are allowed to be in the spreadsheet so don't want them highlighted. But Account "10110-0000" should be highlighted.
I know the Macro will be big but I was hopping something like:
If ActiveCell is not accounts .... I would then list all my account numbers... Then
and at the end a loop until ActiveCell is Empty.
I have this so far.
Range("A12").Select
MyColumn = 1
i = 12
Range("A" & i).Select
Do While ActiveCell.Value ""
[Code] ........
Is there any way to find where in a row of several columns, the total will equal a specific number or cell?
View 9 Replies View RelatedI want to be able to test if a date entered in a cell (Format dd/mm/yyyy) equals a "Monday". If it doesn't, I want to display a warning message.
View 6 Replies View RelatedIs there a formula I can use to return a worksheet name. I want cell A1 on Sheet1 to = the name of Sheet2
View 4 Replies View Related
