| Thread | Last Post | Replies |
|
| Compare workbooks | 28 May 2007 21:15 GMT | 2 |
I have several huge workbooks that I update regularly. Most of the people simply print out the new and discard the old, however some have asked for "changes only" since the workbooks can take a ream to print out, while each worksheet is usually only 1-5 sheets and there can be ...
|
| Index, Match | 28 May 2007 21:12 GMT | 2 |
Is it possible for an "Index Match" result to return data stored in the cell below the index, match intersection? My sheet has catagories in column B, each catagory has six sub catagories. I could just use the sub catagories in the index, match formula, but all the sub catagories ...
|
| Documents to Go AddIn Startup Prob | 28 May 2007 20:10 GMT | 2 |
When I launch Ecxel, I get this error message: "c:\Program Files\Documents to Go\DVZXLAddin.xla could not be found." All I have to do is click the OK button and it launches, however, I would like to get rid of this error message. PLease help. Thanks.
|
| Newsgroup Question | 28 May 2007 19:33 GMT | 1 |
I want to delete this Google Groups account and create a new one, using a different screen name. TIA for advice. James
|
| Workbook not caculating formulas | 28 May 2007 19:20 GMT | 3 |
I have had this problem before and fixed it but I am drawing a blank. None of the formulas in my workbook will caculate until it is saved and closed or the user hits F9. (The user dropped a book on his keyboard and toggled something). I went into TOOLS-OPTIONS_ CACULATIONS and ...
|
| Parallel data series | 28 May 2007 19:19 GMT | 1 |
How can I create a stacked staple chart where I want to compare two years data with the same variables besides eachother per month? ie. jan06 jan07 feb06 feb07
|
| What causes inordinately large file sizes for small spreadsheets? | 28 May 2007 19:15 GMT | 1 |
I had a spreadsheet with several tabs and relatively little info on each page. The first time it was produced, it took up about 800K. I had to redo the spreadsheet and now it is almost 3MB. What could be causing the issue? I am using Office 2003 and I don't see any ...
|
| Beginner in excel | 28 May 2007 18:51 GMT | 7 |
I have set up a stocklist worksheet, and have column J entitled PAYMENT METHOD, in cell J4, I have put number 1 (to represent CASH PAYMENT), number 2(to represent cheque payment, with the amount paid in column K, and the description of the item in column B. I want to enter a ...
|
| number with an automatic color | 28 May 2007 18:51 GMT | 2 |
Good day to everyone, I'm not sure if there is a pssible answer of my question. We keep a worksheets and we input a diffrent figures or number, We had a certain range of number it required to meet the tolerable gain or loss in our operations.
|
| vlookup using dates | 28 May 2007 17:53 GMT | 2 |
User trying to find the value on a certain date can enter that date (a1). vlookup will search column A for the requested date and then return the associated value that is in column b.... Column A10:a100 = dates. Column B10:b100= values... =vlookup(a1,a10:b100,2) returns #N/A
|
| Conditional formatting with IF function | 28 May 2007 17:26 GMT | 2 |
A B 1 Apple 10 2 Apple 5 3 Orange 14
|
| Microsoft Access 2003 on my laptop is missing. | 28 May 2007 17:18 GMT | 1 |
I am a new user of a laptop & am on a "computer course", One exercise is is based on "microsoft Access 2003" file which I cant find on "my Documents?
|
| Automatic Removal of 0's in front of data | 28 May 2007 17:04 GMT | 1 |
I need to input some data into excel, but whenever I type in for example, 00000010, excel will automatically remove all the 0's in front of the 10. However, I actually need to display those 0's, is there any way of changing the settings not to remove them? I've searched ...
|
| Full path-name in title bar ? | 28 May 2007 15:59 GMT | 13 |
Is it possible to put the full path name of the opened file in the bleu title bar from excel, this always en automatically. --> Microsoft Excel - c:/data/stefan/filename instead of Microsoft Excel - filename
|
| COUNT COLOURED CELL | 28 May 2007 15:25 GMT | 1 |
In Excel Sheet there are many cells colored with "RED" and many are colored with "YELLOW" is there any formula to count number of Cells which are "RED" and number of Cells which are "YELLOW".....hope some one understand.......thanks
|