| Thread | Last Post | Replies |
|
| GOTO error reading cell ADDRESS | 18 Jan 2004 21:01 GMT | 2 |
I've run out of ways to try to get the cursor to highlight a particluar cell that is defined by the contents of a different cell. In other words, I want to GOTO the cell that is named in another cell in which the destination cell is identified. The destination cell addresses ...
|
| help with calculating a timetable in excel | 18 Jan 2004 20:18 GMT | 1 |
Look to build a timetable in excel using 8,9, and 10 minute intervals...almost there but not sure what i'm doing wrong...any help you can provide - please email me - thanks!
|
| Literal appears in cell | 18 Jan 2004 20:00 GMT | 5 |
I have an Excel spreadsheet and when I try to sum a column the literal appears in the cell instead of the sum. For example, if I have 1,2,3 in cells A1,A2,A3 and this formula: =SUM(A1:A3) in cell A4, instead of 6 appearing in cell A4 the literal
|
| Copy Group rows formatting | 18 Jan 2004 19:48 GMT | 1 |
Any idea if there is a way to copy my group rows format from one sheet to another? For example I want to group rows 6-24 and 26-38 etc. But I want to copy this from 1 worksheet to 10 others. Thanks in advance Dan
|
| Please help me writing this simple formula | 18 Jan 2004 19:18 GMT | 2 |
How can you look up for data in a particular cell and freeze that cell while draging the formula to other cells. In need for example A2 and A11 remain the same while I am copying this formula to other cells. The problem is when I am copying this formula A2 and A11 will change
|
| =VLOOKUP("a",table1,2,FALSE) is not working for me why? | 18 Jan 2004 18:25 GMT | 5 |
WindowsXP, and Excell 2002 (XP), Celeron 1gig Something is wrong here. I have rebooted. Twice And rebuilt the notebook.
|
| Unsaved text recovery | 18 Jan 2004 17:16 GMT | 2 |
Urgently need to recover text inadvertantly "not saved" when spreadsheet closed. Is this possible? Thanks for any help - desperate Medix
|
| SUMIF for two conditions? | 18 Jan 2004 16:24 GMT | 1 |
I need to sum a range of values checking for two condtions. I check a shift and week number and based on both conditions sum the total hours. I have tried using the AND function without success. I thought it might be possible to join two SUMIF functions, one checking for week ...
|
| teacher's questions | 18 Jan 2004 14:41 GMT | 7 |
I'm a teacher trying to make my life easier but… Any help would be appreciated, thanks. I have a few questions concerning a spreadsheet. It is used to calculate pupils Levels (range 1-9) from their test
|
| Sumproduct help | 18 Jan 2004 14:12 GMT | 4 |
Hi. I am doing a Lunch Detention spreadsheet for my school and I have included 18 different classes on 18 different sheets, with all of the students from the different classes on their respective class rosters. I
|
| Rounding problems | 18 Jan 2004 13:52 GMT | 1 |
I use excell to calculate the 18% tax deduction required for construction workers and then subtract this from the gross pay to achieve the net. If the 18% tax calculation ivolves rounding (I have the
|
| Refreshing pivot table drop down lists | 18 Jan 2004 13:45 GMT | 2 |
How do I get rid of old values in pivot table drop down lists? The original data has been deleted for months, even years, yet, the pivot table drop down still shows them and I have to scroll through the entire list in order
|
| Delete Rows With no "F" in Them | 18 Jan 2004 12:58 GMT | 9 |
Hi All... I would like to get a macro to work that would look through what is selected, if it doest find a "F" anywhere in them, delete all rows in the selection that have no "F"
|
| Question for the Pros | 18 Jan 2004 12:57 GMT | 4 |
When you are writing complex nested formulas, do you type the formula directly into the formula bar or do you use the function wizards? The reason I ask is that I always mess up the syntax when I dont use the wizard for complex formulas. I don't know if using the wizard is a
|
| automatic fill-up columns | 18 Jan 2004 12:03 GMT | 4 |
Good day to all, I have this spreadsheet for our weekly billings. A B C D E s/n Description Section Code Amount
|