I have students Kg-5th Gr. I need to identify the ones over-aged when I enter the information. The following is what I'm trying to use but I get Y1 for ever cell. I need it to Identify the student as Y1 for One year overage and Y2 for tow years overage.
View 3 RepliesI would like to change the greater than number to the value in cell 'I11' in sheet 'Linear Programming Data' and the less than number to the value in cell 'I12' in sheet 'Linear Programming Data'. The code I am using was done by recording a macro since I don't know how to code in vba.
Code:
Sub Results2()
' Results2 Macro
' copy table filter power by greater than and less than
Sheets("Finalizing Results 2").Select
Cells.Select
[Code] .......
I have six images in "Sheet3" I want a macro to copy and paste image one if cell A3 = 0. How do I know the "name" of each picture so I can change the image based on the value?
View 2 Replies View RelatedIf Cell equals text than take networkdays and subtract by a number
If cell c = RD then take cell m (is a date 12/3) and add that by network days +18. This should tell me how many days to process this file.
So I am having trouble figuring out how to do multiple text to equal multiple numbers. For instance right now I use =IF(E9="JOHN DOE","07", but I would like to have it where IF E9 = John Doe the cell shows 07, but IF the E9 = Sam Doe I want the cell to show 08, and the same IF E9 = Pat Doe the cell shows 09 and so on.
Meaning is there a way to have multiple functions go to a cell dependent on what is entered into E9 for example. I just want to have a number come out in one cell if a certain name is entered in a different cell. I loooked at this post [URL]....which got me started,
I want to be able to rank players only if they meet or exceed a specific number of rounds. I have been able to get close but I would like to have the ranking start at "1" instead of "0" (see sheet).
View 4 Replies View RelatedCell A1 = 3
Cell A2 = 4
Is there a formula to calculate
(3*4)+(2*4)+(1*4)
I need to multiply every integer less than the number in cell A1 and greater than zero by the number cell in A2. I was thinking factorial, but that's not it... Can't remember from my math days.
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 have a lot of cells containing numbers. Some numbers are small, some are big.
I want to divide all numbers which are greater than 300 by 1000.
IF cell A2 > 300 THEN divide by 1000.
How to do that? Is it possible to convert value in the same cell like using conditional formatting principle?
I have a spreadsheet that I need a formula so that when a number appears in one column, then automatically it will put text (only) in the adjacent column. I have attached the sample spreadsheet for review. What I need is if there is a number in column A then, put a " / " (forward slash) in column B. If there is only a 0.00 in column A, then put nothing in column B. I tried the IF function an it errored out stating that the " / " was not a number.
View 5 Replies View RelatedI'm Trying to write a code to delete Value in Column E & F If value in Column A = 0. (same row)
I've tried a few methods but none of them work.
Hi, sorry for posting this twice but i wasn't sure which category it fell under!
I have a slight problem with excel and and was wondering if anyone can help.
I have 3 columns, A, B, C: .....
I am using cell V7 to input the formula but I want cell V7 to tell me if the number in U7 is greater than or equal to the individual #'s in cells U7-U40 and I would like it to put a 1,2,3 in the cells of V7-V40 for the three highest numbers in order of largest to smallest if is this possible?
View 3 Replies View RelatedI have number in cell (A1) = 100. when I enter number in any cell of column(B) for example (B1)=10. then in cell (C1) the result of (A1) - (B1) = (90) and if I add in cell (B2)=10 then in cell (C1) the result of (A1) - (B1+B2) = 80 .accumulatively in cell (C1). and any number in column (B), the result will be (A1) minus any number in column(B) accumulated in (C1)
second question
I have number in cell (A1) = 100. when I enter number at cell (B1) = 10 then the result would be in the adjacent cell (C1) = (A1) - ( B1) = 90 and If I enter a new number in cell (B2) = 10 then the result would be in the adjacent cell (C2) = (A1) - (B1+B2) = 80 and If I enter a new number in cell (B3) = 10 then the result would be in the adjacent cell (C3) = (A1) - (B1+B2+B3) = 70 and so on. I want the result to be add automatically to adjacent cell in column (C)
I am doing a spread sheet for to enter the times that i do in a rally.
So if i post a time of 00:49.3 and the target time is 03:54.3 i want the cell to turn red, or if the set time is less then the target time it should be green.
How can i do this in excel
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 RelatedThis is an extract from my workbook.
11661681192203
I need a formula in column d that will return all the missing values between for example b1 and c2 and b21 and c21. The catch is that the numbers in column b and c can be anywhere but row b will always have the starting number and next to that cell the ending number in column d.
a further condition is that it must only calculate the missing number if the value in column a=1. if it is blank than nothing must be calculated.
I have to make a table that shows that a if someone purchases
less than 5 items they receive no discount
5-10 items they receive 2% discount
11-20 items they receive 5% discount
21-50 items they receive 8% discount
over 50 items they receive 10%
and it has to be done in a way that the discount rate can be calculated using Vlookup I am struggling to find the best way to write this table. i tried numbering 1 to 50 and writing the corresponding discount rate in the second column but this looks untidy and can't calculate greater than 50 as i am not sure how to write it in the cell so it reads as >50 and not just 50.
I'm using the code below to extract information from a 'Source' (Remaining Allocation Data) to a 'Destination' (All CTO Expired Assignments) sheet.
[Code] ......
The code works except for this part of the script
[Code] ....
What I'm trying to do is as follows:
Extract records where the FinDate is less than the CurrentDate, (i.e. 19/06/2014) and,
Is equal to and no greater than 28 days prior to the Current Date (i.e 22/05/14)
I've tried all sorts of formulas to try and get this to work including the 'DateAdd' function, but I've so far been unsuccessful.
[Code] ......
How to create a formula in cell M2 that looks at the second row of numbers (0 and 500s) and tells me the rightmost value that is greater than zero. In this example it would return 12.
Second Question: Is there a way to return any counted value, for example the second-to-last number that is over 0?
I have a spreadsheet with rows of data. I need a formula that will return the column number of the last column in a row where there is a value >0.
Let's say that cells A1:F1 contain values. Some have values of 0 while others have values >0. I need a formula in cell G1 that will tell me the column number of the last value >0.
A B C D E F
0 2 5 0 6 0
So the formula in G1 would return a value of 5, which corresponds to column E.
I have a yearly running log (attached). At the bottom in cell [B88] I would like to develop a formula that gives me the number of times I ran in that specific month. Dates are in Column A and running distances are in Column B. If a distance is zero, I don't want to count it. I have attempted to solve this using the =COUNTIFS formula, but I am not able to structure it properly. Maybe =COUNTIFS is not what I should be using.
View 3 Replies View RelatedI need a formula for H2 to multiply the value if it is in any one of the cells in B2 - B6 by the appropriate value to calculate the annual total. Such as if the number is in weekly column it would multiply by 52, fortnightly 26, monthly 12, quarterly 4 and annually 1.
Weekly
Fortnightly
Monthly
Quarterly
Annually
Ann Totals
Mortgage
1000.00
Council Tax/Water/Sewerage
1000.00
I want to calculate ONLY if a cell is > the number manually entered in another cell, otherwise, I want the cell to populate with 0.
I need assistance with combining the following into a single calculation:
IF D11 is > D10, then D14 should = sum of D12-D10
If D11 is
I need to match data in cell A to cell B and then if they equal I need to copy the adjacent cell C to cell X . How do I set up a macro to do this automatically? I have over 5000 cells to compare and match up.. I have Office 2003.
View 7 Replies View RelatedI have column A and B , in Column A cells i have words that I need to count the number of specific letters from them.
like :
A2= Apples
I need B2 to show the number of letter "A" in A2's text.
I've got a single column worksheet with a varying numbers of characters in each row.
At the end of each row's cell value I must add a 5 char string. Preceding that string I must have enough spaces to make the total length of each row 106 characters.
I've already:Defined and populated the string. Let's call it "strMyString".Established how many rows are in the sheet and stored it in "lngUsedRange"Written the following which cycles through each row establishing how many spaces need to be added:
Dim lngSpacesNeeded As Long
For i = 1 To lngUsedRange
lngSpacesNeeded = 101 - Len(Range("A" & i))
Next i
Now I just need to know what else to put before "Next i" to locate the end of the existing text in the cell and add the number of spaces in "lngSpacesNeeded" then add "strMyString".
I have a spreadsheet which has a column that contains route numbers (for collection of goods). Some addresses have 2 or 3 route numbers within the same cell i.e.
3
3 20
3 20 15
I would like to know the formula for counting the number of cells that contain each route number i.e. from above 3 = 3, 20 = 2, 15 = 1
Is there an equation to count numbers greater than zero without adding an additional column?
I had a COUNTIF equation but realized that the criteria that I used to use required an additional column. The additional column I used to have would be something along the lines of =IF(A1>0, "x", "") and then count the X's. I was just wondering if there was another equation that could reduce that step.
With four numbers, I am attempting to "return" a number that is greater than zero, EVEN IF zero is in the array. Meaning, I need the number greater zero, knowing zero is within the array. This will be a part of a much longer concatenate formula.
010 5 0
I would expect the answer to be "5".
I tried: =abs(min(A1:D1))
This works great if there is a negative number (e.g. a -5, rather than 5 shown above), but when the numbers are all positive, the result is "0", I want 5 or the next greater number above zero.