| Thread | Last Post | Replies |
|
| continuous typing | 18 Aug 2007 19:22 GMT | 2 |
I am trying to make one page of my form to be a continuous typing page. I have tried merged cells, wrap text and fit ,but it seems that when I go to print not everything I have typed is on the printed page. Is there anyway I can make this page like a normal page you would find in
|
| Why does it take longer time for re-calculation? | 18 Aug 2007 17:12 GMT | 2 |
Does anyone have any idea on why it take longer time for re-calculation? I get a table with formula for 54 columns x 4000 rows within 1 file, which takes a very long time for re-calculation. However, if I split this table into 3 files, which include formula for 18
|
| Variable Cell Value | 18 Aug 2007 16:53 GMT | 4 |
What formula can I use to express the value of cell A(n+3) where n is a variable. For example, if n = 4 then the cell I'm looking for is "A7". Also, in these discussions what exactly does a "volatile" solution mean vs a "nonvolatile" solution?
|
| headers in Excel | 18 Aug 2007 15:46 GMT | 4 |
I have created several sheets that I use as different forms, one is a billing sheet, and one is a data summary sheet. I need this information to remain in a patient's file and I am constantly changing the headers to include the patient's name and medical record number. Is there ...
|
| Code to Move Several Lines to Master Worksheet | 18 Aug 2007 13:48 GMT | 5 |
I am working with 30+ workbooks which contain timesheets (tabs) for every day a job is worked in our plant. I have inserted rows at the bottom of the timesheets which will gather the information from the timesheet above so that this information can then be moved to the first ...
|
| LOOKUP TO RETURN MULTIPLE VALUES | 18 Aug 2007 13:38 GMT | 1 |
I've been using the following formula with teh cntrl+shift+enter, but I'm not really sure what it does. =INDEX(E:F,SMALL(IF(E:E=E2,ROW(E:E)),ROW(1:1)),2) What I'm trying to get the formula to do, is I have list of 135 user
|
| Calculated field in Pivot Table | 18 Aug 2007 13:32 GMT | 2 |
I am having problems with a calculated field in my pivot table. I have each persons daily time available in a column, the table averages that data for each person, the only problem is the time is in seconds and I want to convert it to hours. It is too cumbersome to manually ...
|
| Unexplained color shift | 18 Aug 2007 13:24 GMT | 2 |
Once every couple of weeks or so (I use excel a lot), for no apparent reason, all the cell background colours (except white) will shift slightly. When I open the color palettes, they have changed too. Closing and reopening Excel tends to help (but not always). I have no
|
| Importing Sort Codes | 18 Aug 2007 12:32 GMT | 2 |
Currently importing banking data that includes sort codes but EXcel 2003 is automatically converting the 01-07-07 format into date format 01/07/07. When I format to Custom or Text it appears as 39264. Any suggestions on a formula I can run to convert them all to the correct ...
|
| leading zero | 18 Aug 2007 11:58 GMT | 2 |
hi community how can i place leading zero infront of number, i am using excel 2007 n if yes!...where can i do the setting ?
|
| Attach Excel File to Word | 18 Aug 2007 11:19 GMT | 1 |
If I have a Word 2003 file, is it possible to attach an Excel 2003 file to the Word document (including page tabs and links)?
|
| SUMIF and SUMPRODUCT with INDIRECT formula problem | 18 Aug 2007 11:17 GMT | 1 |
Afternoon from a sunny RSA, Four sheets, three are input sheets and the last one is a summary sheet. Sheets 1 to 3 are vehicle specific. Truck 1, Truck 2 and Truck 3. One each sheet is three columns, Date, Driver and Kilometers travelled, so
|
| VLOOKUP using two worksheets? | 18 Aug 2007 11:04 GMT | 1 |
Using Excel 2003: I have a worksheet that I have to update daily from data that is created by an SQL query for orders created and not sent. I have to distinguish between production and test vendors. I keep a separate worksheet that has the vendor number & description and status. ...
|
| adding times | 18 Aug 2007 10:56 GMT | 5 |
For my job i have to track my own hours. I am trying to make a sheet that will add up my own hours for me. I have four columns that I type in my hours and then I total it for the day using "=TEXT(G6-F6, "H:MM")". But then when I try to total it for the week it comes up with a ...
|
| LOOKUP TO RETURN MULTIPLE VALUES | 18 Aug 2007 10:44 GMT | 1 |
I've been using the following formula with teh cntrl+shift+enter, but I'm not really sure what it does. =INDEX(E:F,SMALL(IF(E:E=E2,ROW(E:E)),ROW(1:1)),2) What I'm trying to get the formula to do, is I have list of 135 user
|