| Thread | Last Post | Replies |
|
| 'combine' question | 06 Apr 2008 08:54 GMT | 4 |
Perhaps someone can help me with the following question. The function 'combine' tells me that if 12 objects are divided in to groups of 4 items there are a possible 495 combinations. I want to visualize those 495 combinations.
|
| classic pivottable layout | 06 Apr 2008 07:47 GMT | 4 |
I want to know how can I set the default for the classic Pivottable layout in version 2007. I've tried the pivottable options > display tab and checked the Classic Pivottable layout, didn't work. ~thank you
|
| Insert File location to many xls files | 06 Apr 2008 06:54 GMT | 3 |
I have a lot of excel files in a folder that need to be evaluated as keep or archive. Many have different names but are just different versions of the same file....I am going to print all the files out and have our group decide. I want the file name and location on each file. ...
|
| Formatting question | 06 Apr 2008 02:54 GMT | 3 |
excel noob - more familiar with 123. I have a db program which exports data in xls format. This I import into excel and massage as necessary. It's basic columnar accounting data - date/check#/payee/reason/amount. I need to print this data in a specific
|
| date | 05 Apr 2008 21:36 GMT | 3 |
using 2007 when doing fill down the date changes from 28.03.08 to 28.03.09 any idea why??? AFD
|
| Problem adding column of figures | 05 Apr 2008 21:27 GMT | 1 |
Using Office 2007 Excel Usually I highlight the column and press the SUM icon where I want the total to be placed. However, there seems to be a previous formula within the column, as the incorrect total
|
| Blank entry in an IF statement returns FALSE. I want it to be blank | 05 Apr 2008 20:17 GMT | 2 |
When I have no entry in a cell within an IF statement it returns as "FALSE". I want it to be blank and have no value. If I use if(ai="","") I still get FALSE unless the entry is done via the spacebar and then I get a blank cell. How do I get a blank cell
|
| sumif values are same | 05 Apr 2008 19:47 GMT | 6 |
How do I sum column A if the value C is common? A B C 15.2 2 aa1 23.0 1.5 aa1
|
| Visual Basic in Excel 2007 | 05 Apr 2008 19:36 GMT | 2 |
I have used a visual basic routine to save the date and time when I save an Excel file. Private Sub Workbook_BeforeSave(By Val SaveAsUI As Boolean, Cancel As Boolean)
|
| Error Message | 05 Apr 2008 19:07 GMT | 3 |
When I open Excel I get this error message: "Compile Error in Hidden Mode AutoExecNew" and get this one when I close Excel: " Compile Error in Hidden Mode. DistMon". How do I resolve this? Thanks, David
|
| Add name to list | 05 Apr 2008 18:32 GMT | 1 |
I need help with Xcell 2003 program as I have difficult time following the help instructions. I have a list of names arranged by last name, first name, E-mail affiliation. I want to add a new name. I write it in the empty space where the little star is at the bottom of the list, ...
|
| Excell spreadsheet in MS Office 2007? | 05 Apr 2008 18:30 GMT | 1 |
How do I email a spreadsheet.
|
| Vlookup | 05 Apr 2008 16:55 GMT | 13 |
I am trying to do my homework again. I have done everything I can to get this to work and I keep getting error messages. I am trying to get the letter grade on 3 worksheets. I have a forth worksheet that has the criteria for the letter grades. I have a list of
|
| Break links | 05 Apr 2008 13:02 GMT | 1 |
I want to break a link in a given workbook. Edit > Links > etc. But the "Break link" button is missing. What's happening here? Robert
|
| Worksheet_Change sub routine | 05 Apr 2008 13:02 GMT | 1 |
I am trying to understand various points of the programme listed below and given in a book as an example (I have deleted some of the lines of code not necessary to this question, and commented some of the lines – the original had no commenting):-
|