| Thread | Last Post | Replies |
|
| password protect column | 26 May 2006 20:41 GMT | 1 |
How do you protect a column by a password once it is hidden. I have spreadsheet that I have to share with others (send as attachment) an there is a piece of info in a column that has to b protected.Absolutely protected
|
| Setting Reminders | 26 May 2006 20:38 GMT | 1 |
Is there a way to set a reminder so when a date in the spreadshee column is a week old it will notify me -- EmpireNikk
|
| Multiple Filters in one Sheet | 26 May 2006 20:34 GMT | 1 |
(I have read through this disccussion group and it seems that this is not possible but I think my situation might be different...) I am trying to filter two or more columns seperately. For example, in the first
|
| Excel 2002 | 26 May 2006 20:30 GMT | 3 |
I am a financial analyst and I use Excel a lot. Yesterday I lost the "drag" capability. By this I mean, if you are adding two columns or more of data, you calculate the formula for one column and then drag that formula to accompanying colums.
|
| Function for hours | 26 May 2006 19:52 GMT | 7 |
Hi, Thanks for letting me join your site. I've been looking for a site that will help me with excel. Thanks Here is my first question: I need to calculate the amount of hours i spent on a job. Example: I started at 2:17 AM and finished at 7:34 AM.
|
| Cell calculate only once | 26 May 2006 19:41 GMT | 1 |
How can I have a cell calculate only once? Example: Equation in cell D7 "=A1+B1" So if I create this equation in cell D7 yesterday and A1 and B1 both equal
|
| Excel worksheets | 26 May 2006 19:33 GMT | 1 |
Is it possible to set up Excel worksheets with some pages landscape some portrait?
|
| Subtotalling | 26 May 2006 19:14 GMT | 3 |
After recent updates from Microsoft I am having trouble stacking subtotals. I was not having this problem before. I believe it started with Service Pack 3. Help I am working for my office and can not easily get the info I need.
|
| find | 26 May 2006 19:06 GMT | 3 |
Hello, for some reason when I try to use the find tool, its not working. For example, I go to the edit menu and click on find. In find what I put Paul, the within is set as sheet, search is set to by columns, and look in is set to values. When I click on find next, it says ...
|
| comparing column values | 26 May 2006 18:51 GMT | 4 |
I have two columns with product numbers in them. The first column has product numbers from the begining of the month. The second column has product numbers from the end of the month. I would like to compare them against eachother and find all the new product
|
| Extracting Dates | 26 May 2006 18:42 GMT | 3 |
I have dates formatted as 12-Jan-1967 (in A1) and 11-Jan-1967(in B1). How do I tell Excel to take the date 12-Jan-1967 in C1 since I want only the dates from/after the 12th day of the month? Since the dates are stored as numbers is there a way to check for the first two digits
|
| How to perform calcutions only if value if greater than zero? | 26 May 2006 18:37 GMT | 1 |
How can I set up a formula in Excel to perform only if the value in a cell is greater than zero?
|
| mix font styles in concatenated text | 26 May 2006 17:46 GMT | 2 |
Can any one tell me how, in Excel 2003, to have certain words written in bold typeface in a concatenated string. For example : =CONCATENATE("I, the undersigned, ";A3;"do hereby confirm etc etc") which gives
|
| where is the function wizard in excell?? | 26 May 2006 16:52 GMT | 1 |
I cannot find the function wizrd or the paste function in excel. They are not talking about the regualr paste feature... And i cannot find it in the help section or anywhere i look.. Thanks
|
| Index Match Two columns Find Last Bottom | 26 May 2006 16:49 GMT | 4 |
Thanks for all your help in the past, I have a list of data containing lets say two columns. I need to find the bottom or last which meets the criteria of column A. For instance, Column A Column B
|