| Thread | Last Post | Replies |
|
| Is there a function to insert the worksheet name into a cell? | 07 Mar 2007 22:26 GMT | 3 |
I have MS Office Excel 2003.
|
| Extracting information from table | 07 Mar 2007 22:13 GMT | 2 |
I have a table as follows blue green yellow 4 jane heidi natalie 3 bruce sharon fred
|
| Toggle Between Tabs Within One Worksheet | 07 Mar 2007 21:55 GMT | 1 |
Are there any hot keys that allow you to toggle between tabs within one worksheet? I am familiar with Ctrl+Page Up/Down, but that isn't entirely what I am looking for. Any information would be great. Thanks.
|
| Macro to move files gets an error if it already exists... | 07 Mar 2007 21:46 GMT | 6 |
I have the following macro snippet that moves a txt file AFTER its data has been imported into a spreadsheet. It works great as long as the file doesn't already exist. Function TXTFileMove()
|
| Countif? | 07 Mar 2007 21:33 GMT | 1 |
I'm trying to do the following: Count how many cells (rows) in coloumn A that has the value 1 in Column C AND value 1 in Column D... How do I go about this?
|
| Array Help | 07 Mar 2007 21:24 GMT | 3 |
I would like to create an array that is built off of criteria that I specify. For example, if column A contains numbers and column B contains letters, I would like to create a formula that would return all of the letters associated with number 12. Any help would be greatly ...
|
| difference between + or = in entering a formula | 07 Mar 2007 20:54 GMT | 3 |
I'm a long time MS Excel user and working with it on a daily basis, I find myself puzzled with it sometimes. For instance,... What is the difference when entering a formula with a + or an = sign?
|
| automatically roll the page number after you print | 07 Mar 2007 20:43 GMT | 3 |
I am trying to create a form that will automatically change to the next number in the sequence after a copy is printed. Is this possible in excel and if so how is it done?
|
| Help! How to Remove Read Only Status on a Worksheet | 07 Mar 2007 20:22 GMT | 1 |
I have put a read-only status on several files--so different branches can look at but not change. I think I should have just password-protected them instead. I'd like to remove read only status on the files instead of copying them to different locations---does anyone know how I ...
|
| Time Value of Money | 07 Mar 2007 19:33 GMT | 1 |
I have a number which increases each year by 3% at a certain date. What cell entry can I input to have this number increase automatically per year dependant upon that date. For instance, I have a # 2532, which increases by 3% every year on September
|
| Subtotal of Abs of a range? | 07 Mar 2007 19:26 GMT | 3 |
Greetings! Am stumped. Need a sum of the absolute value of row-filtered elements in a column. SUBTOTAL does this admirably, but it appears that SUBTOTAL does not accommodate anything but a simple range as it target, in the pseudo-syntax SUBTOTAL(Function,Range). SUM, on the ...
|
| How do I create a CountIF statement for a range of items in a list | 07 Mar 2007 19:21 GMT | 1 |
I want to be able to create a table with one column providing a list of companies with the counts of their values in a series of other columns. In the column where the original company data comes from, the company names appear more than once in the column (but now I am wanting ...
|
| Page & Chart Numbering | 07 Mar 2007 18:53 GMT | 2 |
Howdy- Here's what I have: 17 tabs in a workbook (8 tabs are worksheets [with single print areas] and 9 tabs are charts.)
|
| Data Validation for Null | 07 Mar 2007 18:27 GMT | 2 |
i am new to data validation. I want to create a data validation so that cells can not be Null. Should I use Custom and if so, how would I write the formula. What is the best way to accomplish this?
|
| How to make a key float in an excel wksh when a person scrolls. | 07 Mar 2007 18:23 GMT | 5 |
 Signature Kelly C
|