| Thread | Last Post | Replies |
|
| Comboboxes | 21 Nov 2006 10:05 GMT | 1 |
Hi. Hoping you can help me. I recently found out what a gret program Excel is and how much you can with it; this is what I would like to do. I would like to create a combobox with information. Depending on what the user chooses in this combobox a different combobox will change it ...
|
| Excel 2007 Table Styles | 21 Nov 2006 06:36 GMT | 2 |
If you create a new table style in Excel 2007 is it possible to save it for use in future workbooks? Thanks Janet
|
| Creating a new list with Last Order Date | 21 Nov 2006 04:10 GMT | 2 |
I do have a customer transaction history. I would like to get the latest order date with amount in to another sheet instead of all the orders under same account number and bring the rest of the corresponding info to the other columns. Such as bill to information
|
| lookup over multiple ranges | 21 Nov 2006 04:09 GMT | 1 |
I want something to the effect: =if(iserror(vlookup(a1,range1,2,false)),vlookup(a1,range2,2,false),vlookup(a1,range1,2,false)) but I want to do this without using an if iserror function. Is there a way to do this? An array formula perhaps?
|
| Blank cells | 21 Nov 2006 01:54 GMT | 2 |
I have an exported file that looks something like this: A B 1 NAME AMOUNT 2 Indiana Finance 100.00
|
| making frames in a spread sheet? | 21 Nov 2006 00:48 GMT | 4 |
Does any one know how to make a spreadsheet in to frames? i tried freeze pane but what i really want is to separate the worksheet into frames like a webpage, so if i scroll down the right side, the left side and the top side won't mvoe...
|
| RE: Excel data exported to custom Outlook form | 20 Nov 2006 23:32 GMT | 11 |
Greetings earthlings, I have an issue that I have been trying to resolve for sometime, I think I will provide the scenario and hope someone has an answer. Here it is. - I have Excel workbook called "users.xls"
|
| Use of "--" in functions?? | 20 Nov 2006 23:19 GMT | 3 |
I'm new to compiling and using functions of anything other than a relatively simple basis. I've been reading a lot of questions and answers on this group and am amazed at some of the complex functions that can be built up.
|
| conditional formulas | 20 Nov 2006 23:01 GMT | 2 |
Please, I need help with these formulas . . . 1.) if worksheetC!C12 says "1" then I want worksheet D!E18 to say "1" , but if C!C12 says "2" then I want D!F18 to say "2" 2.) if worksheet G!C12 says "G", thenD!I31 should say "G", but if G!C12 says
|
| Sum a table of columns & rows | 20 Nov 2006 22:34 GMT | 4 |
I have a spreadsheet of 154 Rows (all unique project numbers in numerical order) and 9 columns of account numbers (some are similiar and some are user entered, therefore there could be 'blanks' with no data in them). I am trying to create a table that will only give me the ...
|
| labels with excel | 20 Nov 2006 21:57 GMT | 3 |
How do I create labels from an excel spreadsheet? I've followed how to get it to mail merge in windows but when i get to the select recipient dialog box, that's it, it won't put the info into the labels created in word
|
| Missing OLE DB Providers in Excel 2003 | 20 Nov 2006 21:56 GMT | 1 |
I have a strange problem with Excel 2003. I've the full product installed and I'm trying to connect to Analysis Services 2005. I've installed the OLE DB Provider for SQL Server 9.0 When I try to connect to SSAS, I cannot select an OLE DB Provider as
|
| Slow scrolling in Excel XP | 20 Nov 2006 21:53 GMT | 1 |
I work with Excel a lot. I've come up against a few weird things in it but this one I haven't been able to solve on my own and have not seen it reported anywhere else so I thought I would post it up. I have a problem with a large pricing model I have developed in Excel
|
| Office2007 Laundry List of Gripes | 20 Nov 2006 21:52 GMT | 11 |
Some of these are admittedly nit-pickey... but they add up to what is a truly horrendous User Interface and extremely disappointing version of Office. 1) On my Silver themed WinXP, Word, Excel, and PowerPoint are BLUE, while
|
| Business Objects and Excel | 20 Nov 2006 21:50 GMT | 1 |
I have a Business Object Report that outputs to an Excel spreadsheet. I want to format the spreadsheet and save it before sending it out to users. The problem I have is that when I finish with the formatting, I cannot
|