| Thread | Last Post | Replies |
|
| Counting Instances Of Item In A Column | 05 Jun 2005 01:39 GMT | 15 |
I have a table with data along the lines of the below. A_______B______________C_______D 1_______Success/Fail_____Type_____Time 2_______S______________X_______34
|
| Trying to write a formula that changes which worksheet to used | 05 Jun 2005 01:35 GMT | 5 |
I am trying to write a formula that uses a different worksheet in the current workbook depending on the value from a lookup result and/or the direct entry of a worksheet name in one cell. For instance, if my lookup result is November, I want to pull information
|
| need help deleting space in cell with data | 05 Jun 2005 00:52 GMT | 5 |
I have pasted a 1000 dates in the format mm/yyyy However, when pasted in, the dates all have a space at the end of the last c harachter. I want to delete that space so Excel recognizes field as a
|
| creating help info for user defined function | 04 Jun 2005 23:56 GMT | 3 |
I have some custom functions written, and would like to provide a little note on the function variable input box that explains what the function does (the same as microsofts functions have tips). Can anyone help with doing this?
|
| how to type in excel | 04 Jun 2005 23:08 GMT | 1 |
typing letters or numbers do not show in excel
|
| how to change a cell content in a visual basic function? | 04 Jun 2005 21:48 GMT | 3 |
myfunction() is a function i called from, lets say, cell C3 as: = myfunction() in myfunction() i want to change a cells value: ......
|
| no lotus 123 key in excel 2003 tool/option/transition? | 04 Jun 2005 21:30 GMT | 3 |
I installed microsoft office 2003 recently. No more lotus 123 help at transition settings for me to be selected anymore? I mean the transition navigation key. Where is it in excel 2003? I need lotus 123 / command from time to time.
|
| Clear cell when value is 0 | 04 Jun 2005 19:52 GMT | 4 |
I saw an excel spreadsheet whereby when a user enters any number in any cell the numbers remain with no change. But when a user enters 0 (number zero)
|
| Result of date as Month-2 digit Year | 04 Jun 2005 16:58 GMT | 3 |
I have columns of dates that the users must enter as actual dates. I can format to display month and two-digit year...but when creating pivot tables it reconizes the entire date. Since I want to summarize only by month and year or by year only, is there a formula or statement ...
|
| locking or grouping rows | 04 Jun 2005 16:39 GMT | 4 |
I have made an address book and find that I am unable to sort it. I "think" I need to group several rows. 1st row: name > street number > children names > Home Phone 2nd row: > city, state, zip > more names > Cell Phone
|
| Deleting All Range Names | 04 Jun 2005 14:03 GMT | 3 |
Is there an easy way to delete a group of range names or all the range names in a sheet at one time? The only way that I am aware of is to delete each range name separately.
|
| Training Source for creating Excel Pivot Tables | 04 Jun 2005 13:27 GMT | 1 |
I am wanting to find some good training sources for creating excel pivot tables. I currently use pivot tables...but need to go beyond the basics I have learned by trial and error. Thanks.
|
| Merging 3 Workbooks without using macros | 04 Jun 2005 11:56 GMT | 1 |
There are three of us that keep track of data for our respective departments in Excel but would like to merge only certain data into one master worksheet so our boss can see a general snap shot as to what we are doing. Is it possible to merge our workbooks automatically as we ...
|
| dates in excel | 04 Jun 2005 10:02 GMT | 1 |
I have a need to automatically save the current date to a cell in an excel spreadsheet every time the sheet is saved. Today() always returns the current date, so once I open the sheet on a new day I can no longer see the date the information was last updated, i.e. saved. Any help ...
|
| lost password | 04 Jun 2005 09:53 GMT | 2 |
I have forgotten a password of the worksheet I protected. Now after long time when I tried to unprotect it I just could not unprotect it. Could someone help me please overcome this problem. Please. Thank you
|