| Thread | Last Post | Replies |
|
| One question | 16 Jun 2007 13:58 GMT | 4 |
If either column A has "yes" or column B has "yes", column C should show "yes" too but if BOTH columns "A" or "B" have "N/A" "C" should say "N/A", A B C Yes no yes
|
| Omer | 16 Jun 2007 13:53 GMT | 9 |
Can any body tell me how to do this if either column A has "yes" or column B has "yes", column C should show "yes" too for example
|
| Delete cells. | 16 Jun 2007 07:21 GMT | 3 |
Can any one give me a formula or a macro that will automatically delete whatever i have in the cells below. I dont have anything specific text or numbers that can be identified in the cell to delete them (inorder to use Auto filter). I just need them blank.
|
| Equation Help | 16 Jun 2007 03:51 GMT | 2 |
I can't figure out an equation, or if an equation for its even possible. I'm using Excel 2003 My spreadsheet has multiple columns, but they repeat. A is 'Part number' B is 'Parts Completed' C is 'Date Completed'.
|
| Principal Amortization based on variable cash flows | 16 Jun 2007 02:30 GMT | 1 |
I am trying to build an amortization schedule that would help me determine my bond borrowing capacity however it needs to be based on variable semiannual payments versus leveled payments. Has anyone done that before and has any suggestions on the formulas to use.
|
| Customize view | 16 Jun 2007 01:46 GMT | 1 |
When using the print preview view is it possible to remove or hide the gray page numbers?
|
| I need help with removing "enters" that are separating data in a c | 16 Jun 2007 01:43 GMT | 5 |
I have data that has been downloaded from a tool and sometimes comments are listed in one cell wiht the "Enter Arrow" in between the items which cause issues. Is there an way to remove the arrows in the column of data? Example :
|
| Set print area for entire workbook | 16 Jun 2007 01:38 GMT | 3 |
How can I set the print area to be the same for all the pages of a workbook at one time? I am using MS Office Excel 2007 Thanks for any help!
|
| Changing the order the addins load | 16 Jun 2007 00:13 GMT | 2 |
Is there a registry setting that allows me to change the order that Excel loads addins?
|
| date format not correct | 15 Jun 2007 23:22 GMT | 3 |
Hi. I've created a spreadsheet Book1.xls, set the dateformat, set a few cells, but the date displayed is not correct if the day number <= 12. My Windows locale is "English (United States)", short date is "6/15/2007", and location is "United States". Created a new xls file Book1 ...
|
| Looking up A name in a table and reurning all rows that are associ | 15 Jun 2007 22:37 GMT | 3 |
I am trying to lookup a persons name in a table. Then return ALL the rows that are associated with that name. HELP. IE: Sheet1-A2 has the name I'm looking for
|
| Emailing ONE WORKSHEET not ENTIRE FILE in Office 2007 | 15 Jun 2007 22:12 GMT | 1 |
We use to have an option to email current worksheet only or entire file in the older Excel. That option window no longer pops up when I attempt to send the current worksheet in Excel 07. How can I accomplish this?
|
| Date format - India/USA | 15 Jun 2007 22:05 GMT | 7 |
Hi ... We are having date translation problems between India and the USA. I need to know how the Excel format *3/14/2001 will behave between an operating system on mm/dd/yy format and an operating system on dd/mm/yy format.
|
| disabling excel 2007 | 15 Jun 2007 22:03 GMT | 3 |
I need to have both Excel 2003 and 2007 because some programs I use for my business aren't fully compatible with 2007. Is there a way to temporarilly disable 2007 so that when a program attempts to download a file to Excel, it will open 2003 NOT try to open 2007
|
| Multiple match statements? | 15 Jun 2007 22:00 GMT | 7 |
I am trying to match 3 data points and return the value for the cell they intersect at - without using concatenate if possible. In the below table I would like to return the value for Product A, Country UK, Week 2 i.e. 20 - any ideas?
|