| Thread | Last Post | Replies |
|
| Preparation and Summarisation of data | 24 Sep 2004 04:00 GMT | 1 |
Hello I need to prepare my data and I need help My problem is like so: I have data like the following Time, A, B
|
| comments to Autoshapes | 24 Sep 2004 01:41 GMT | 5 |
Would anyone happen to know how I add a comment box to an autoshape i excel 9 -- Kathryn Steadm
|
| Sorting out data by date | 24 Sep 2004 00:27 GMT | 1 |
My problem is I have an imported spreadsheet from access tha shows the date, Name of company and amount of goods.I then have seve spreadsheets one for each day of the week. I need to put the record for the right day on the right spreadsheet. the imported spreadshee
|
| shared workbook file wont open for one users | 24 Sep 2004 00:20 GMT | 1 |
we have a shared workbook......and when one particular user tries to open it ......it starts to open and then closes. Now when i open the file under other accts its fine....and i lock to see who has it open under tool, share workbook, it shows that that user with the problem ...
|
| Conditional Formatting For "David" | 24 Sep 2004 00:13 GMT | 1 |
Dave I stucked with it, read more and with what you wrote I finally got the time to work correctly, thanks a bunch, Gee this was a bear for me. I'm going to read up more just in case I need it later.
|
| Repeating garbage in excel file, need help | 24 Sep 2004 00:12 GMT | 1 |
At work we are using Excel 2000 and have a workbook that contains several grids. Each grid contains formulas to calculate averages and percentages. This month after the report was completed I saved it and printed out the grids. For unknown reasons after I saved it that day when ...
|
| row height changes | 24 Sep 2004 00:08 GMT | 1 |
Dave The printer is a network printer and the driver is loaded from th server. Both computers would have been installed the same way using th same server.
|
| How to: text color depend on value | 23 Sep 2004 22:59 GMT | 3 |
Anyone know how to make the text change colors, depending on what valu certain data is? I'm sure it's easy... -- bobsmith58
|
| Change of range in a formula | 23 Sep 2004 22:55 GMT | 11 |
I have a simple spreadsheet where E2 is the sum of B2:D2, and so forth for each row. If I insert a column after D2, so that F2 should now be the sum of B2:E2, what is the proper formula that will automatically adjust to the the new
|
| Count between a Date Range | 23 Sep 2004 22:18 GMT | 1 |
I have a number of columns that has dates in them and blank cells, and would like to count the number of instances a date?s falls in betwee current date and earlier. I have not been successful using the eithe the Countif ,Sumif, or Sumproduct formula.
|
| GETPIVOTDATA Turn Off | 23 Sep 2004 21:47 GMT | 2 |
How do you stop the GETPIVOTDATA function. When I create pivot tables if I want to work with data within the table this function makes it impossible Example: Table Result Formula
|
| Email excel | 23 Sep 2004 21:16 GMT | 4 |
I have a 12 page workbook that is sent via email very often. To discourage clients from changing the workbook I convert it to PDF (with Easy PDF Writer) and sent it as an attachment. Works great... EXCEPT when the client will not accept emails with attachments.
|
| Removing Blank Rows | 23 Sep 2004 20:52 GMT | 3 |
Having trouble finding a way to remove blank row on a spread sheet this is what i need i hav a sheet like this 546 6574 7484
|
| I need to filter based on colour | 23 Sep 2004 20:38 GMT | 4 |
Hello I have a spreadsheet of Excel 2003 in which in one column (column B) there are entries coloured yellow and some with no colour (white). I need to filter and see only the yellow entries . But I need to filter all the columns of the spreadsheet based upon the yellow colour of ...
|
| Excel | 23 Sep 2004 20:10 GMT | 1 |
Where will I find the command that will show all formulas on a page. Can't find. Thanks
|