| Thread | Last Post | Replies |
|
| How do I create a Demo Excel Program | 06 Feb 2008 18:39 GMT | 2 |
I have created an Excel VBA program (as Add-In). I want to create a Demo version of this Add-In (for prospective users) which will stop working after a specified number of days (after installation). Can anybody give me an idea how to go about this?
|
| Formula | 06 Feb 2008 18:22 GMT | 3 |
I am making a worksheet in excel and I have a YES NO cells. I would like to be able to black out the cell I want to answer. Ex. if my answer is yes I would like to click on the cell and it would automatically turn black. Is that something that would be possible? could you use ...
|
| Circular reference, Maximum number of formulas | 06 Feb 2008 17:56 GMT | 1 |
I have come across a spreadsheet in Excel 2000 which exceeds the 65536 number of formulas that Excel's dependency table can keep track of. The consequence is that 'Calculate' is permanently diplayed in the status bar, AND (much more important), it cannot keep track of circular ...
|
| Excel deleting some numbers from an excel document | 06 Feb 2008 16:55 GMT | 1 |
I have a spread sheet that has (example) numbers in a cell 45% (5/11) in a cell or 60% (60/100) in a cell. I have hundreds of cells each with different series of numbers all with a 1-2 or 3 diget % and two numbers in (). I want to delete the number in parenthesis and the ...
|
| Stumped on combinations | 06 Feb 2008 16:38 GMT | 6 |
I am stumped on a complex combination problem. I need to create all possible combinations to fill grids 7 columns wide with set parameter restrictions. Parameters are: 1) the number of columns the grid will take 2) the number of times 'x' is to appear in the columns, going ...
|
| Excel functions - need some guidance. | 06 Feb 2008 16:12 GMT | 1 |
Hi. I assume that I'm missing something with functions here. Suppose I've got the following data... Item # Type Qty Value 1 baseball 52 $40.00
|
| formula for selecting ans averaging | 06 Feb 2008 15:41 GMT | 3 |
Hello: I have a data row from a3 to z3 that is added to weekly. I need a formula that will select the top 10 values from the row and average them out. Changing the answer as the data is entered . The data input will range from - 0 to 65. thanks
|
| Spreadsheet issue | 06 Feb 2008 15:41 GMT | 3 |
I have a spreadsheet which states either yes or no that a report was filed on time and then following responses of whether the report was complete or not, etc. I need another worksheet in the same workbook to count the number of
|
| Formula and field types for calculating times | 06 Feb 2008 15:35 GMT | 3 |
I don't get it how to format fields and apply some formula to calculate with time-differences. Example: I want the difference of two time fields expressed as
|
| Using conditional formatting in Excel 2007 | 06 Feb 2008 13:55 GMT | 3 |
This is probably a stupid question, but I am creating a database, in which I want the cells in ex. range A2:G57 to highlight a certain color, but only if the cell in the same row has a value of 1. Please understand that I don't want all of the cells (A2:G57) to change, just the ...
|
| My Paste Function button is missing from the toolbar. | 06 Feb 2008 11:40 GMT | 4 |
My Paste Function button is missing from the toolbar. I clicked on the pull-down menu at the end of the toolbar, and cannot find it among the extra buttons that you can add to the toolbar. Please help. Thanks in advance.
|
| At what times do the "moving ants" appear around a cell? | 06 Feb 2008 10:47 GMT | 1 |
Why do "moving ants" appear around a cell when you are creating a formula, and what other times may they appear?
|
| Problem with viewing 2 sheets within the same Excel workbook using dual monitors | 06 Feb 2008 08:19 GMT | 1 |
I am able to get Excel to display 2 different sheets within the same workbook (one sheet on each screen). However, when I page up or down on one sheet, the other sheet also moves. Does anyone know how to lock down one of the sheets? When you're trying to look at formulas
|
| Data tables ? Circular references ? | 06 Feb 2008 08:05 GMT | 1 |
If I setup a data table as follows: A1=0 A2=0 A3=A1+A2
|
| how do i set up a excel program for seniors membership/dues, etc | 06 Feb 2008 03:22 GMT | 1 |
I need to download a program that will be easy to use. i sign in as confused senior
|