| Thread | Last Post | Replies |
|
| Problem with CSV file | 21 Nov 2007 15:37 GMT | 6 |
A customer has sent me a csv file which contains two sheets when opened in Excel 2000. This was done because the first sheet contained the maximum number of records Excel can handle. I need to import these lists into Paradox (a database), so I need to separate the two sheets into ...
|
| Creating a report with .jpg files in it | 21 Nov 2007 14:54 GMT | 1 |
I need to create a report to document equipment performance that will include the usual columns with text information. I wish to include .jpg screen caps in the report. I would like to use a hyperlink but I want to make sure that the spreadsheet and the .jpg files cannot be ...
|
| SOVER ADD IN | 21 Nov 2007 14:52 GMT | 1 |
I PURCHASED STUDENT AND TEACHER EDITION A YEAR AGO. 7041-056-3526131-56025. MISPLACED DISK. REQUIRES FILE E4561412.CAB TO COMPLETE INSTALLATION OF SOLVER. HOW CAN I GET THE FILE WITHOUT MY DISK?
|
| Fixed & Reducing Balance Loan Calculation. | 21 Nov 2007 14:35 GMT | 3 |
Could anyone, please guide me following two questions. Loan Calculation For Fixed Annual Interest Rate Reducing Balance Annual Interest Rate
|
| using time format in a formula | 21 Nov 2007 14:35 GMT | 3 |
I'm trying to use a formula that if c3 is >:45 seconds then etc....vlookup the score that relates to that specific time
|
| counting data across worksheets | 21 Nov 2007 14:19 GMT | 5 |
I need to do the following:- I have 12 worksheets (one for each month) which contain information on staff members, when they were on duty, when they were on holiday etc. I have successfully used COUNTIF to work out how many days holiday each
|
| Copying year | 21 Nov 2007 13:49 GMT | 2 |
1.How can copy the months with same year i.e. Mar 2003, Apr 2003, May 2003 etc because as I drag the cell containing Mar 2003 down, the year gets incremented 2. Last week I have created marina.xls file which was working fine. But
|
| Opening Excel 2003 File | 21 Nov 2007 13:48 GMT | 1 |
I have a file saved correct. For example the file name is water.xls. When I open the file water.xls it opens and I can edit it. However, the file name has changed to water1 (without .xls). I can reopen water.xls, while water1 is open and the new name is water2 (without .xls). This ...
|
| DBF File | 21 Nov 2007 13:38 GMT | 2 |
How can I save as dbf 4 file in Office 2007?
|
| counting blanks in a non-consecutive range | 21 Nov 2007 13:38 GMT | 3 |
I need to be able to count the number of blank cells in a range, but my range is made up of non-consecutive cells, ie B2, D2, F2, H2. I have tried naming the range 'actual' and then using =COUNTBLANK(actual) but I get #VALUE!
|
| Repetive Formatting/Creating a Toolbar button | 21 Nov 2007 13:38 GMT | 11 |
I work on different worksheets all of the time and have to choose format (on different cells specific font withing the cell). I normally right click on the font within the cell I need to format and choose format, select Font, change the color to red, and choose strike through. ...
|
| Password | 21 Nov 2007 12:36 GMT | 2 |
Incase if I forgot the password of my excel sheet? Is there any option to open that sheet?
|
| file replace | 21 Nov 2007 12:10 GMT | 2 |
I have 3 users working on a series of linked Excel files all feeding to a final output file (STRATEGY OUTCOME 2007 WIP.xls). The files are not shared. Last night one of the user A had the final output file open (STRATEGY OUTCOME 2007 WIP.xls) - she had full access. User B saved ...
|
| vlookup looking at many worksheets | 21 Nov 2007 11:36 GMT | 2 |
I have a problem with one of my spreadsheets. I have worksheets for 12 months of the year(Jan-Dec) and a summary sheet. The format for each sheet and summary sheet has names down one side and code names going across as shown.
|
| count 2 column | 21 Nov 2007 10:21 GMT | 2 |
I would like to count following criteria. Do there any formula can help IN Excel ? Closed LCD Closed LCD
|