| Thread | Last Post | Replies |
|
| Circular reference | 15 Jun 2004 16:58 GMT | 3 |
I've searched and searched, but to no avail. Mayhap someone here is m final hope. I have an iterative formula which is as follows: T=SIN(T)+6.023*T^0.4
|
| copy and paste excel charts as same size | 15 Jun 2004 16:54 GMT | 3 |
I have a workbook that I need to make many charts in. And most of these charts are the same from page to page, just with data from a different sheet &/or series. I want to copy and paste one chart several times and then update the
|
| spellnumber | 15 Jun 2004 16:03 GMT | 5 |
The help i requested for number to to be spelled in indian rupees , i have the excel vba code but do not how to get it run in excel , code as below hope you can help me . Sub Macro4()
|
| Show blank cells as red with conditional formatting | 15 Jun 2004 15:25 GMT | 6 |
Hello, what formula can I use with the conditional formatting dialog to show cells that are empty as the color red. Thanks in advance bartmacl
|
| counting specific figures in cells dependant upon contents of adjacent cells | 15 Jun 2004 14:46 GMT | 2 |
I have 3 columns. The first has single digits (0-9), the second ha various numbers with x's and blank spaces in between, and the third ha a 0,1 or 2 in it. I am able to count the numer of blanks in column 2 every time a
|
| Help on SUMIF please! | 15 Jun 2004 14:45 GMT | 2 |
Hi, I have a spreadsheet where I am trying to insert a function in a cel which would say: 'Display the sum of cells B5, C8 and B10. If the value contains th
|
| Re-sizing the Excell window | 15 Jun 2004 14:44 GMT | 2 |
For some reason I cannot re-size the Excel window on the desktop. I cannot click and drag any border to resize the Excel window. I often need to see two or more programs side by side (including Excel) to accomplish the task I am performing. I can minimize the Excel window but not ...
|
| Filters | 15 Jun 2004 14:03 GMT | 1 |
Why do filters only work with less than 1000 rows? Is there any way round this? Thanks in anticipation
|
| How do I show a checkbox in a cell holding a true/false or yes/no or 1/0 value? | 15 Jun 2004 11:29 GMT | 1 |
I'm sure I've seen this in Excel spreadsheets before, but can't find an example anywhere and I'm getting frustrated with the help system's insistence on showing the answers to completely irrelvant questions I just didn't ask.
|
| Searching tables for similar entries | 15 Jun 2004 05:47 GMT | 3 |
Hi, I have this customer table and a transaction table on another file. Is it possible to search the transaction table and calculate values on the transaction table and put it in the customer table? e.g
|
| autonumbering a column in excel | 15 Jun 2004 05:42 GMT | 1 |
How would I go about autonumbering a column in excel?
|
| this workbook contains queries to external data | 15 Jun 2004 05:42 GMT | 1 |
I opened a excel document and this message shows "this workbook contains queries to external data that refreshes automatically." How can I modify this workbook so that I can get rid of the queries and not show this message again. I am not sure if this is a virus or it is in the
|
| Lock or freeze A portion of a formula | 15 Jun 2004 05:07 GMT | 3 |
I want to lock or freeze a portion of a formula when I drag a formula o copy it Ex. =FREQUENCY(A1:A217,J8) I want to freeze the portio A1:A217 but I want J8 to chang relative to the location Thanks in advance
|
| Age Formula | 15 Jun 2004 04:51 GMT | 6 |
I need to compute ages (as of 6-1-04) from dates of birth on a speadsheet I'm working on. I have NO idea where to start on that. Help please? Thanks in advance!
|
| Excel hiding everything except the work on the sheet? | 15 Jun 2004 03:45 GMT | 1 |
I am wondering if there is a quick way to hide all the columns outside the rows and columns not used in my spreadsheet? Currently I do this by selecting and dragging but the rows take a while to get to the end. Is there an easier way to do this?
|