| Thread | Last Post | Replies |
|
| how do I make an excel comment box bigger? | 18 May 2006 17:39 GMT | 5 |
I am looking at an excel worksheet that was sent to me. There are several comments on the sheet. One of the cells is too small and I cannot read everything that is in the comment box. How can I make this box bigger so that I can see the entire contents
|
| Can you perform Math functions with ActiveX Checkbox controls? | 18 May 2006 17:23 GMT | 1 |
Is it possible to use a series of ActiveX controls (Checkboxes) and then do a math function, such as COUNTIF to count the number of check boxes that are checked (true)? What should be used to determine the state of the checkbox and what would the proper syntax be?
|
| divide by zero | 18 May 2006 17:01 GMT | 3 |
i have 2 cells: f4 and f8 on status spreadsheet. they may not be populated, (have a value in the cell), all the time. need a formula that will calculate when only both of them are populated. and not return a #div/0!, divide by zero error. when neither or only one of those cells ...
|
| Comparing against first non-blank cell | 18 May 2006 16:59 GMT | 1 |
Okay, here's the problem: I have two columns: A and B. A is a listing of stock prices, in random order. B is a column of Peaks or Price Highs, based on column A.
|
| Sort function on Pivot Table | 18 May 2006 16:58 GMT | 2 |
Does anyone knows why Pivot table do not sort properly if your sort is based on 2.3.or 4... column. I have tried many times and always resort to 1st Column. I have also tried the Advance function of Pivot Field. Thank
|
| copying macros | 18 May 2006 16:51 GMT | 2 |
A colleague of mine wants to create several macros that the whole team can use. He intends to put these macros onto a drive that we can all gain access to so we can open the workbooks. Once the workbooks are on the shared drive, how do we copy them into the
|
| Excel Woes - Formula bug (I guess) | 18 May 2006 16:44 GMT | 3 |
Problem: an excel file is being used for quite some time now (about 2 years), and it suddenly stops updating cells with formulas...for example: =SUM(c1:C10); the cell is not updated when a value is added to say... c5. Does anyone know what is happening?, I hoping that I can get
|
| US states | 18 May 2006 16:44 GMT | 1 |
Does anyone know how to convert US states on excel? e.g., TX = Texas.
|
| Sumproduct-multiple criteria for same range "OR" | 18 May 2006 16:43 GMT | 3 |
I found a solution to my problem.... However, to designate "or" between multiple conditions existing in a *single* range, you can create an array of these "or" conditions, using an array constant, as:
|
| Newbie post - help with Subtotal please! | 18 May 2006 16:38 GMT | 9 |
This is my first post so I hope it is in the right forum. I have a spreadsheet with subtotals on and we have a problem inserting new rows. I thought that when a row was inserted above the subtotal row, the subtotal would update automatically - but it doesn't.
|
| excel "Networkday" function | 18 May 2006 15:55 GMT | 2 |
How do I assign current calendar date to end_date in order to calculate # of days worked from hire date to current date?
|
| Function to Convert dollar to text? | 18 May 2006 15:00 GMT | 2 |
I am looking for a function to convert a dollar amount (number) to text. For example, $10.50 would display as "Ten Dollars".
|
| PivotTable | 18 May 2006 14:53 GMT | 1 |
I am usually really good at figuring things out, but this has me totally stumped. I have a spreadsheet which contains the following headings: C-section Indication Main Method of Delivery Aux Method of Delivery Physician 1
|
| Automatic League Sort | 18 May 2006 14:37 GMT | 4 |
I have a league table (attachment table named 'World Cup League'). I updates scores as i enter them into a data table that precedes i (titled 'Games Won'). I would like to be able to automatically sor the 'World Cup League' in descending order every time i enter data int
|
| IF statement colored results | 18 May 2006 14:29 GMT | 1 |
In an IF statement is possible for true and false results to be different colors?
|