General
in [Excel]
|
Calculate the difference in date/time formatted cells I need to know how to find the difference in time in two cells with a date/time format of 05/01 04:30 ... 14 May 2010 15:02
Is there a way to have an excel read only auto refresh after save We are using a master workbook to track open customer orders. It requires a password to write so that it can not accidentally be changed. Several user's leave it open as read only during the work day. Is there a way for these users to see any updates made and saved during the time it is open as read only? ... 14 May 2010 11:43
action items- sorting through multiple worksheets by employee name I've got action items from various meetings each in their own 'meeting' tab. The problem is, when a new meeting tab is created, or an old one is updated with a new action, the person assigned to the actions won't know about it unless they hunt for it (and most times they arent aware of it until it is too late!)... 14 May 2010 15:02
How do I copy a custom footer to other sheets I have set up a custom footer with several items in and need to do the same to lots of other spreadsheets. It would be great if I could copy the footer, paste it in another worksheet and just amend minor details. Can this be done? ... 14 May 2010 11:43
Formula question OK, here is the problem: I have a worksheet, a very large worksheet that looks like this: Column a 1 1 1 2 2 2 2 2 3 3 3 I need a formula that tells me how many ones, how many 2s, and how many 3s are in the column. I have about 1 million numbers and need to apply the formula to the entire column.... 14 May 2010 10:37
Combo box output excel 2007 Hi everyone Hopefully somone can help me with my combo box problem. I am not any expert in Excel so please keep any answer as simple as possible ;) I want to use Combo box for budget matters. For example if i have a list of different items such as: A1 A2 Gloves 1$ Bananas... 14 May 2010 11:43
Email Macro I want to write a macro that will on the click of a button email the document as an attachment to a pre defined mailing list via Outlook....any help??? cheers, ... 14 May 2010 09:30
How to reverse column values in excel? I have values in a column like: 546 3242 54 5645 257 245 1565 i Want to make them in reverse order as : 1565 245 257 5645 54 3242 546 Can any one help me... ... 14 May 2010 18:20
conditional formatting I have a column of dates and I want to highlight in red all dates that are equal to and more than 3 years old For example if the date is 02/10/04 this should be highlighted in red. I would appriciate anyones help! ... 14 May 2010 05:11 |