| Thread | Last Post | Replies |
|
| How do I retreive a replaced excel workbook? | 17 Oct 2007 05:14 GMT | 2 |
My office assistant asked if I wanted to replace a workbook that already existed and I clicked on yes, accidently and I need it back desperately. Please help
|
| Check Boxes | 17 Oct 2007 02:58 GMT | 4 |
I have a workbook with multiple worksheets. On worksheet 1 I have 10 check boxes (Cells A1 to A10) that, when checked, links the data in Worksheet 1 (Cells B1 to B10) to Cells B1 to B10 on Worksheet 2. Cell B1 on Worsheet 1 is linked to Cell B2 on Worksheet 2 and so on. The ...
|
| Unwanted dash | 16 Oct 2007 23:45 GMT | 5 |
sorry if this has been posted before, i didnt know what to search for. I am sorting out my company invoice, in the sub total column i have for example "=E24*F24" and so on, then at the bottom I have another sum adding those up to give me the overall total.
|
| Adding columns to an Excel matrix and listing them in the PT | 16 Oct 2007 23:44 GMT | 1 |
I have an Excel matrix that I need to add additional columns to. When I add the columns they do not show up in the Pivot Table List of items to be added to a pivot table or report. How do I make them visible in the PT list?
|
| CountA, Subtotal and "move to the first cell in the next column" | 16 Oct 2007 23:30 GMT | 1 |
Help, I am using the"CountA" Worksheet function to paste data from another sheet into the 1st empty cell starting at "B2". It works fine all the way to row 14 but it continues to row 15.
|
| Excel 2007 :Standard Footer | 16 Oct 2007 23:21 GMT | 1 |
Can someone tell me if I can set up a standard footer that will appear on every excel document that I create. Basically I want the footer to appear on every new workbook that I create from scratch. Thanks
|
| match and insert from one workbook to another | 16 Oct 2007 23:16 GMT | 4 |
I have a project to match SSN's between 2 workbooks and insert columns from one sheet to another. Example: File1
|
| I have misplace my Excel 2003, 25 digit code, how do I get a repla | 16 Oct 2007 21:51 GMT | 2 |
How do I get Excel 2003 25 Didgit Product Replacement code?
|
| SUMPRODUCT not working. | 16 Oct 2007 21:19 GMT | 2 |
Hi I have the follwing grid A B C D E F G
|
| formula to find a value | 16 Oct 2007 21:10 GMT | 2 |
I have a spreadsheet with 2 worksheets, on the first worksheet I have 3 columns, column A has a number between 1 and 50, column b has a number between 1 and 10 and column c has text string that varies. On the second worksheet I have set up a grid with 1-50 in column A, and 1-10 ...
|
| CREATING A FORMULA | 16 Oct 2007 20:56 GMT | 4 |
I'm hoping I can find someone who can help me create a formula to use in a spreadsheet. Let me explain what I am trying to do. I have two workbooks that I intend to link so the end result in one workbook will appear in columns in the linked
|
| Find and Delete Row | 16 Oct 2007 20:33 GMT | 1 |
Need some help... I'm trying to find ANY text in a column and then delete the entire row. In other words, if there is text in B3, B8, B16, etc., I want to find the macro to find it and then delete the rows 3, 8, 16, etc. These are
|
| Deleting numerical values within a cell | 16 Oct 2007 20:10 GMT | 10 |
I have a column with numbers and text - I want to delete all numerical values and leave the text intact. Any help would be greatly appreciated.
|
| Match Date/Time to Date list | 16 Oct 2007 19:09 GMT | 4 |
I have a Date/Time in A1 (mm/dd/yy hh:mm) and a list of dates (mm/dd/yy) in D1:D10. I would like a formula to compare the date/time to the date list and return "yes" if it is in the list and "no" if not. Thanks
|
| countif function using dates | 16 Oct 2007 19:06 GMT | 7 |
I want to calculate the number of entries in a column that are later than one date and earlier than another. This is what I thought would work, but doesn't: =COUNTIF(M3:M158,">30/09/2007"&"<01/11/2007")
|