| Thread | Last Post | Replies |
|
| Find duplicates in data with multiple criteria | 14 Dec 2007 15:56 GMT | 1 |
Hello - We are trying to create a list for holiday cards this season. However, when we imported everyone's information into an excel spreadsheet, we received duplicates which were to be expected. I did a subproduct on two of the fields, Last name and Company and managed to find ...
|
| Delete row if all cells are blank, Excel 2000 & 2003 | 14 Dec 2007 15:55 GMT | 1 |
I have a worksheet with 1061 rows and 7 columns of data. Example: column A B C D E aa bb cc
|
| OLE control for workbook hidden field | 14 Dec 2007 15:38 GMT | 1 |
In Excel under the Window menu there are hide and unhide menu options to hide and unhide workbooks. However, the workbook object does not have a visible or hide property. How, using OLE, can I view and change the hidden status for workbooks?
|
| IF AND FORMULA | 14 Dec 2007 15:37 GMT | 1 |
I need a formula for the following: If tab 'The Worker Be! cell B8 = SuperModule AND tab 'Stibo Calculations' cell S8 is not = to C. than add 85 + ('The Worker Be!' cell F8 * 225) * 'The Worker Be!' H8 * 'The Worker Be! X8
|
| Filter nonblank AND unique | 14 Dec 2007 15:34 GMT | 1 |
Is there anyway to filter using multiple criteria: nonblank AND unique?
|
| one or more invalid names were detected in this work sheet | 14 Dec 2007 15:34 GMT | 2 |
Every time I start up excel, it appears a warning "one or more invalid names were detected in the work sheet. those invalid names have been changed to #REF!". What is problem? How to fix it up? Please help me.
|
| Dates change when copied to new workbook or worksheet | 14 Dec 2007 15:29 GMT | 2 |
I'm sure this is just something I don't know about....but when I copy a spreadsheet with dates (all in the past week - 2007), to a new workbook, the dates all change to 2003. Any idea why this is happening? Is there a formatting option I need to have selected before I copy?
|
| Excel Macros from 2003 to 2007 | 14 Dec 2007 15:29 GMT | 1 |
Will my macros from the previous version of excel transfer to Office 2007 seemlessly?
|
| It's not a date or time. | 14 Dec 2007 15:29 GMT | 2 |
Hi, I'm exporting data to Excel from another software program. When the data is in excel, there is one column that contains numbers and colons (e.g. 10:10:80). Unfortunately for me, Excel sees this as an improper date/time entry and gives me a decimal number instead. Is there ...
|
| Fitting text into a cell problem. Please help! | 14 Dec 2007 15:27 GMT | 3 |
Hi a colleague of mine is trying to fit a lot of text into a cell however once he reaches acertain point the text dissapears from the cell and is replaced with ####. The text is still visable within the formula bar. I have tried increasing the size of the column and row and ...
|
| Help with return values on IF/THEN | 14 Dec 2007 15:27 GMT | 2 |
I am trying to write an if then statement, where if the amount in a cell is greater than zero it will return the value in another cell. IF (a3>0, then "A5") can't link to the A5 cell and A5 is returned. If (a3>0, then C3=A5) won't work....getting an error.
|
| opening a file with wildcard | 14 Dec 2007 15:08 GMT | 1 |
The following script enables me to open a file and bring specific data into a different workbork. Problem : Once the data is in, I ask to go back to the initial file "abc_SCCS_1*.csv" in order to close it but I get a Run-Error 9 : Script out
|
| When i put A in Cell A1 i need excellent to come up in B1 | 14 Dec 2007 15:01 GMT | 2 |
When i put A in Cell A1 i need excellent to come up in B1
|
| Tell me which "season" (Month/Day through Month/Day) a date (Month/Day/Year) falls in (any year)??? | 14 Dec 2007 14:59 GMT | 1 |
I have a list of dates, and I need to find out which season each one falls in. From all of the date researching that I have done, I cannot seem to get my answer. Here is the issue. I have a list of dates:
|
| Excel 2007 - Calculation Problems | 14 Dec 2007 14:41 GMT | 12 |
I am using Excel 2007, and have a large file (11MB) that is giving me problems. The file is used to forecast revenue opportunities for a 4 year period, and then calculate the recognized revenue based on the timing of deals, revenue type etc. and is approxiamately 735 rows by 1700 ...
|