Total newbie trying to use excel for work here. I have two problems that both need the use of "is NOT in another column". 1. I need to count the number of instances in a column that do NOT have the word "fly" in column G. The current formula is...
I'm currently using this formula to show the last date of a entry ie A15, on a 2 different worksheets, the forst worksheet always has a A15 entry and the 2nd worksheet currentmonth! sometimes has and entry.
It is an example of a list of menu items that I need to put a tick next to whichever item (instead of a 1) in order for the cost of the item to appear in the B column of the Menu Costing Combination sheet. Without the tick the amount does not appear.
How do I go about putting the tick mark in the cell instead of having to put a 1? Of course, the formula in column B will have to be changed in order to replace the number 1.
I need to be able to enter text in a box, and from that box the formula looks at the text to see if it is in within strings of text in any other box in the entire spreadsheet. If the text is there, the box needs to turn green (or any color). If not, it stays the same. The catch is I need the formula to be in a separate box, and the Entered text will be in a blank cell, so the user (who is excel illiterate) will not be confused by the odd formula.
B1, B2, C2, D4, and D6 will have the items: XXX, YYY, ZZZ B3 and B4 will have only: YYY
In the "search box" the user will enter XXX
B1, B2, C2, D4, and D6 turn green, while B3 and B4 stay as normal.
If they enter YYY in the search box, all of them turn green.
I'll try to keep this brief. Our part #'s look like this. XP014567. Where the first pair of characters stand for a value(say XP=Bolt), the second pair stand for a value(01= Grade 2), and so on. What I would like to be able to do is type in the part numer and have the description automatically populate. Is there an easy way to do this? I'm running Excel 2003.
I have a large spreadsheet with many pieces of equipment in it. There are a few piece that I would like to highlight should thier computer license go out of date, or even better 30 days prior. I have a Feild with the Expire dates but it is at the end of the spreadsheet not in plain sight. Is there a way to make my Equipment description column highlight when the date in the other column reaches the current date (or 30 Days before). I have cut and pasted the part of the spreadsheet into a new file to make it easier to read and hid all the none important feilds.
I am looking for a formula that will work with my current formula, and check that cells a1 and b1 contains information. If they do contain info then the original formula should carry on as usual and leave the answer in cell c1. I also need it so when no information has been entered in cells A1 and B1, C1 will be blank instead of containing a zero.
This is the formula I have at the moment: =IF(SUM(A1=0,B1>0),B1-A1,"No Charge?")
I assume I would need a macro, but I am wanting to have a button where-by the user clicks to create another 100 rows and in-turn, continue the formula's that reside within the columns and rows above, down...
The test takers are shown three pictures. Under each picture is a number. So for example, let's say there is a plane, a car and a train presented for question #1. Underneath those pictures are the numbers 1, 2, and 3 respectively. Those numbers represent a tendency to a certain occupational field. After 55 questions, we can make a pretty good recommendation of where we think they should look for a job (without going into the specifics of the test).
There are 11 occupational fields. In excel, I make those fields A through K. In field L1 through L55 I put in their answers.
Let's say that in all 55 questions, for example, answering 1, 3, and 5 lead to vocational choice K, I want it to tally it up for me automatically. I don't want to have to count those by hand.
I just want to put in the patients answers, and have excel do the work. I tried using the "countif" function, but it doesn't look like you can add multiple conditions.
I need something that will be like this: add 1 each time (as in a tally) to the cell I choose, for the answers that I specify. So, ultimately, it will be tallying up the answers based on which categories that I correspond them to into the respective cells.
So to be redundant... Let's say that answering 3, 7, and 9 to questions 1, 2, and 3 pertain to cell B. After I put those in, I want cell B to have the number 3 in it.
I have a formula that looks like this : ='G:STOCKS[1001 Stock.xls]Matl%'!$I$32
There are hundreds of similar formulas, all referencing different cells in the same file. The 1001 bit refers to the date, and next month it will need to say 1002 to pick up the new month's file. I would like to hold the 1002 bit in a cell (say A1), so that at month end, I just change that one cell, and all the formulas will point to the new file, but Im not sure how to work that into the formula.