| Thread | Last Post | Replies |
|
| Windows in Taskbar - NOT WORKING :( | 27 Apr 2004 23:09 GMT | 9 |
Hi, I have multiple Excel worksheets open and I like to ALT+TAB between them. This was all fine until recently when it no longer shows the workbooks in the taskbar. The option "Windows in Taskbar" is checked. I've tried unchecking it,
|
| Run-time error 6 | 27 Apr 2004 23:06 GMT | 5 |
Gretings, As part of a routine to create worksheets the following macro looks at a list and deletes any duplicates. The routine works great unless there is only one cell occupied in
|
| Problem | 27 Apr 2004 22:58 GMT | 1 |
I have One Cell whose value is constantly changing once a week. Input in WK3, resulting calculation ends in cell M3 M3 is copied to worksheet2, A1 (=worksheet1M3) I got this! Input in WL3, resulting calculation ends in cell M3 (again)
|
| Locking a Cell after It's Value is Calculated. | 27 Apr 2004 22:54 GMT | 3 |
I have One Cell whose value is constantly changing once a week. The results of that cell, I would like to have placed in differents cells, once a week. EX:
|
| Looking for security | 27 Apr 2004 22:18 GMT | 1 |
I have developed a small application for time and billing. Not only do i want to secure the source code but specifically want to secure it so that any customer that buys this, cannot email it to their friends and let them use it.
|
| Rescale | 27 Apr 2004 21:41 GMT | 4 |
I need to rescale student scores to reduce the fail rate, for example if our exam failure rate exceeds 25% (ie 25% of students receive exam score of less than 50%) then I need to amend the pass score so that at least 75% of students have passed. How can I acheive this using Excel? ...
|
| Opening Workbooks | 27 Apr 2004 21:18 GMT | 2 |
When I open up many separate excel files, the files all open up in th same excel workbook. How can I have the files open up in separate workbooks on my toolbar a the bottom instead of always having to go to window and choosing th
|
| Please help, I know nothing | 27 Apr 2004 20:59 GMT | 4 |
I am a very new at this and it is driving me crazy. For example, I want to add all of column A + column B and I want the answer to go in C. I want this action to always happen automatically. How do I do this...in easy, non-math language?? I understand the basic concept of the ...
|
| Finding Minimum value | 27 Apr 2004 20:50 GMT | 4 |
I know the formula for finding the minimum value in a range is =MIN(G7:G31) But how do you find the minimum value and ignore all the 0 values? Thanks
|
| Format Painter keyboard shortcut? | 27 Apr 2004 20:23 GMT | 1 |
Does anybody know the keyboard shortcut for Format Painter? Thanks, Dave
|
| View Duplicate entries | 27 Apr 2004 19:57 GMT | 11 |
What would I need to do to view duplicate entries. I have a mailing list, that i get new data in excel every week Id like to view duplicates on a separate sheet so I wont stain my eyes looking thru thousands of entries any help is appreciated.
|
| Formatting issue with numbers when saving as csv | 27 Apr 2004 19:40 GMT | 5 |
Hi - I am using excel 2000. I have a spreadsheet that is an export from ms access which contains prices of products in one column. The number format of these cells is general. When I save this spreadsheet as a .csv file, the prices that showed as
|
| Consolidate rows on susequent sheets. | 27 Apr 2004 18:53 GMT | 13 |
Excel 2002 On sheet 1 I have data imported from an Access database. The data consists of individual sales that are made by a number of different sales people. In column "B" are the salesperson's names, and going accross in the subsequent
|
| match record field | 27 Apr 2004 18:46 GMT | 2 |
I have a simple excel table where 5 users enter records on the same spreadsheet throughout the week. In one of the fields (columns) the user will enter his name to identify who the record belongs to, and in another field is the date that record was entered. I end up with a table ...
|
| Can a workbook be used as a function | 27 Apr 2004 16:21 GMT | 1 |
I have an excel workbook (A) that givern three parameters, temp1, temp and flow calculates the energy transfer for a process we conduct, have another workbook (B) which contains the hourly logged data for th process from which we generate monthly reports.
|