| Thread | Last Post | Replies |
|
| How to easily crash Excel 2002. | 06 Sep 2009 22:55 GMT | 2 |
Excel 10.2614.2625, at least. In a VBA module, enter: Function x(a) As String Fubar
|
| Need help adjusting time | 06 Sep 2009 17:52 GMT | 7 |
I am trying to figure out how to develop a cell formula that will adjust the time on entered data. I use Hobo data loggers to collect temperatures every 4 hours from October to May. I set the time on the logger at launch according to a WWVB radio
|
| Question: Relative CPU Usage of SUMIFS & SUMPRODUCT | 06 Sep 2009 17:26 GMT | 16 |
I'm building an Excel model that will summarize data from a table (18,000 rows x 65 columns), and I want to minimize the number of calculations / CPU utilization. So my question is: Is it more efficient (CPU utilization) to use SUMIFS or SUMPRODUCT?
|
| creating chart | 06 Sep 2009 16:25 GMT | 2 |
i am new to excel and need to learn how to create charts. does anybody have any good tutorials?
|
| Lookup table with click-and-select? | 06 Sep 2009 15:49 GMT | 9 |
Can someone point me in the right direction? I have several thermos bottles of various sizes that I use for tea. I have several varieties of tea that require different brewing parameters.
|
| wrap text inserts a padding blank line | 06 Sep 2009 15:15 GMT | 1 |
I use Excel 2003 (11.5612.5606). I thought I had a row autofit problem; I actually seem to have a wrap text problem. I have a cell in which the text can fit in one line; when wrap text is set, the cell is two lines deep.
|
| cannot print A4 size how do i do it | 06 Sep 2009 10:21 GMT | 3 |
how do you print in A4 size
|
| importing a table in powerpoint to excel | 06 Sep 2009 06:48 GMT | 1 |
how do i go about importing a table in powerpoint to excel?
|
| my right and left arrows won't move to next cell | 06 Sep 2009 05:49 GMT | 1 |
My excell spreadsheet was working fine then all of a sudden when I hit the right arrow instead of moving to the next cell the whole page moves over but i'm still in the same cell. I can't type in another cell unless I click on it with the mouse. What is happening? I don't know ...
|
| Invoice numbers | 06 Sep 2009 02:43 GMT | 5 |
I have no idea what JE is. Please assume you are talking with a novice. I am trying to get a simple way of putting in a cell a formula or code that will give me a sequential number every time I open the template of an invoice. So far I do not have an answer that I can follow.
|
| Getting sheetname that calls a macro. | 06 Sep 2009 02:04 GMT | 3 |
Is it possible to get the sheet name that a macro is called from. I am using the code below to make a backup when the macro is called but it can be called from any of 31 sheets. Code =
|
| rota template | 05 Sep 2009 23:09 GMT | 1 |
Anyone has a rota template for 20+ people operating 2 shifts?
|
| Application Quit does not work | 05 Sep 2009 21:31 GMT | 14 |
When I have the personal file loaded the Application.Quit does not work. I close all workbooks in a macro before I use the quit statement but it still does not work. Any Ideas?
|
| Saving Previous Data before editing | 05 Sep 2009 18:48 GMT | 7 |
I have an excel sheet where I input the expenses of my department for a particular Month to get the total expenses for that month. Month: Aug-09 Preventive Maintenance Expense: 25.3
|
| MAXIF? | 05 Sep 2009 14:29 GMT | 4 |
I want to find the max of a range of cells in one column that has many cells with #N/A. I have noticed that I can find the average of the range by typing =AVERAGEIF(B2:B109,">0") and now I want to find the MAX as well, but there is no MAXIF() formula.
|