| Thread | Last Post | Replies |
|
| space left for future entry = #DIV/0! | 24 May 2006 14:46 GMT | 3 |
I'm making a sheet to calculate my grades, but since its the beginning of the semmester, the spaces aren't filled in yet. How do i ignore a cells until they have a value?
|
| Text Wrapping not working as desired. | 24 May 2006 14:27 GMT | 3 |
I have a workbook containing several worksheets. The specific worksheet of concern is set up to allow the user to fill in information and as such will be protected to eliminate the risk of changes. All cells have been set as Protected except those where the user is allowed to ...
|
| Compunding Interest | 24 May 2006 14:14 GMT | 3 |
I have had to give up trying to do this myself. I have a total of £2000 in cell 2A. The monthly net interest is 0.02% in cell 2B The number of periods is 12 in cell 2C
|
| Flag row if cell values = something specific | 24 May 2006 13:38 GMT | 5 |
Let's say A1 = top and B1 = Bottom in C1, I want to say that if A1 = top and B1 = bottom then the cell background color of C1 should be red.
|
| Converting weight | 24 May 2006 12:51 GMT | 2 |
I have a spreadsheet and I want to have four columns: A - kilogram B - stone C - pounds
|
| Tracking Changes | 24 May 2006 12:46 GMT | 3 |
Hi Folks - I'm trying to get a handle on tracking changes. I turn it on. I make changes. Excel 2003 displays the changes in comment boxes. All is well. I save and close the file. I open the file. The changes are not visible. Can you help?
|
| Increase months by number from next column | 24 May 2006 12:19 GMT | 5 |
Hope someone can help on this please. I have 2 columns, Column A contains numbers Column B contains dates in this format: 22-May-2006
|
| Indices - Agreed Standards? | 24 May 2006 12:02 GMT | 3 |
I have inherited a file which converts survey feedback (questions with multiple choice answer options of 'up','down' & 'level') to indices. The calculation gives an Index of between 90 and 110, with 110 indicating totally positive feedback(up) & 90 indicating totally negative ...
|
| need to edit excel spreadshhet | 24 May 2006 11:58 GMT | 3 |
I have a column in spreadsheet excel, I have 30,000 items and I want to drop the last line which is "Shipping charges wil apply to orders under $100.00" this line is in every cell as the last line of the description column. Is there a formula that will work?
|
| Prompt Message Query | 24 May 2006 11:08 GMT | 1 |
Now, I know that we all hate Excel's paperclip 'helper'; however, have been asked to create a worksheet that once a cell has been fille in the l'il bastard pops up and gives a prompt for what the user shoul do next (e.g. 'Go to Sheet2').
|
| formula for adding / subtracting two columns . | 24 May 2006 10:50 GMT | 2 |
Can't find formula to add or subtract two or three entire columns in a spread sheet Thank you
|
| Macro Password | 24 May 2006 09:49 GMT | 1 |
Is there any way we can crack the password assigned to any macro to hide the vb program text from viewing by any body else. I have a macro prepared by me which was protected by password and now I am not able to remember the same.
|
| Averages with blank cells and specified criteria | 24 May 2006 08:07 GMT | 5 |
Hi, I am trying to develop a formula to have attendance reports and averages. I want to divide the groups into adults, youth and children. I have a column identifying the group each person is in (A Y or C). I have a worksheet for each program (wed, thurs, fri or sun) and i want to ...
|
| Column Forumulas | 24 May 2006 08:05 GMT | 1 |
I'm sure this is simple, but i suck with excel. Okay, I want to mulitply column A by column B and paste the product into column C. For example, A2 x B2 = C2, but for say, 100 rows without having to do it by hand.
|
| A Time Format Problem | 24 May 2006 06:25 GMT | 5 |
I remember reading this on this or another Excel group, and now can not find it. Please help Column A and B contain Start and End time. Column C calculates elapsed time =B2-A2
|