Summary: Hi All, I am using office 2003.while i am working with excel files,the formulas are not working.everytime i need to press F2 to get the result. Is the...
Summary: I have two columns of data that I need to compare using some formulas (vlookup, conditional sums, etc..) my problem is that while the two columns appe...
Summary: Last month I posted a question about making a formula to check lotto numbers. A lotto bingo where the numbers are accumulative until someone matches ...
Summary: If the following table is what you wanted: Group 1 5A1 5B13 5C1 5D13 5E5 Group 2 5A2 5B12 5C2 5D13 5E2 Group 3 5A3 5B11 5C1 5D2 5E12 Group 4 5A4 5B10 ...
Summary: Trying to open an HTML file (created by Oracle reports) with Winword.exe gives a c0000005 (access violation) error. The DrWatson dump is as follows: A...
Summary: 0001 BD 944251 2 If 0001 and BD are not in the same field they will need to be using =A2&B2 and drag the formula down the entire column. You can do th...
Summary: I have been using this equation and it has worked fine: =IF($F2=12,$L2*0.00046,$L2*0.000656) This equation resides in col. M. Explanation: If amt in c...
Summary: I believe that the F2 key will move the cursor to the end of the text in a field. You could run a macro when the field has focus using the SendKeys fu...
Summary: Not sure if I understand but hit F2 to Edit Cell. When done adding your text go to Format, Cells, Alignment and select "Wrap Text". When adding your t...
Summary: when i opened a .doc file written in russian... all i get was this(without the inverted commas): "Content-Type: text/richtext; name="Pushkin - Winter ...
Summary: Hi I'm not sure about other versions but in Excel 2000 the following works. Use arrows to move to the cell then press F2. It will place the cursor at ...
Summary: If you need a quick fix, does this help? Edit your copied formula via F2 to delete the braces {} at each end then position cursor at the end of the fo...
Summary: I'm trying to edit a series of cells in Excel by adding a letter at the start of the text in each cell. Example: Old cells abcdefg hijklmn opqrstu N...
Summary: I need to change the format of a long range of cells in a column. When I change the format the cells do not change to the new format until those cell...
Summary: Open Windows Explorer to the folder that contains the files. Highlight the one to change and press F2. You can then rename the file. Life's more pai...
Summary: If you are willing to settle for 2 data entry points, one for Speed No and one for Model, VLOOKUP() would be pretty simple Let's say your data is set ...
Summary: This seems to work... It's really long for 2 reasons: 1 - With just the Concatenated IFs, it always returns a trailing comma. I eliminate that by usin...
Summary: You will need to create the fromula in each row changing the weighted values for each question as you see fit. In column F of each row simply use =SUM...
Summary: Mirtha If your data is in columns A:E, in column F add a formula to produce a proj of 001/002 if the proj is 001 or 002 otherwise producing the normal...
Summary: I wanted to thank everyone for their responses. It has helped alot. I am not too familar with VBA scripting yet, but I will def be giving it a try. ...
Summary: That's tough to answer based on the wording in your question. "or not even running a shift that day" How many days a week is your plant open - 5, 6, ...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
