| Thread | Last Post | Replies |
|
| Text to columns | 16 Apr 2008 21:01 GMT | 6 |
I have exported a table from MS Access to Excel to be able to use it as a mailing list. When I try to convert text to columns I am unable to enter the text delimiter as it is some sort of white square, well in fact there are two squares together. Can any one help?
|
| if Statement | 16 Apr 2008 20:50 GMT | 2 |
I would liek to compare 2 cells and if the value is =X then have another cell put up a message i tried if(j24="X" andJ25="X",L18 = "You can only select 1 value",L18="") obviously doesn't work
|
| Default file location | 16 Apr 2008 20:46 GMT | 1 |
I change the default file location in tools/options, but it always reverts back to the original location. Any thoughts or suggestions would be welcome
|
| Error - Incorrect Function | 16 Apr 2008 20:41 GMT | 5 |
I have the following code in a addin to close a spreadshhet and go back to the menu. Everything works fine but i keep getting a error message Incorrect Function. Sub backtomenupo()
|
| Excel 2007 macros - how to merge 5 macros together into one | 16 Apr 2008 20:36 GMT | 1 |
i have several macros i want to put together as one macro. How do I do this
 Signature Sue
|
| vlookup | 16 Apr 2008 20:31 GMT | 2 |
Is it possible to use vlookup when the information is in a Pivot Table? I'd need to compare information from 5 column within a Pivot table to 5 column within a Pivot table and one column that's not part of the Pivot. I'd like to pull the information from the column that's not part ...
|
| Another Hide Columns Question | 16 Apr 2008 20:31 GMT | 2 |
I am running Excel 2003 and need help with a macro. I have a table consisting of Region, Stores and Monthly Sales. I wrote a macro to filter (hide) Stores depending on the Region. Region Store Sales City
|
| Excel Calendar | 16 Apr 2008 20:29 GMT | 1 |
Is there a tutorial for creating and excel calendar and using it?
|
| Ramdom selection with criteria | 16 Apr 2008 20:01 GMT | 2 |
I am trying to select 15 random numbers from a list of 65 (A1:A65), I also only want numbers that match a set criteria (B1:b65 = x). Is that possible?
|
| excel formulas | 16 Apr 2008 19:51 GMT | 2 |
I have an excel fine with data both text and numbers against different names. What i want is to find a formula that can collect all the data against a specific name provided as condition in a formula. For Example Column A Column B Column C
|
| White text prints as black | 16 Apr 2008 19:38 GMT | 3 |
I have multiple cells with multiple forms of conditional formatting. If a certain cell has a number, the information in others will be visable and cell will be shaded. If another cell is empty, another set of cells will not be visable and not print. The text and cell shading ...
|
| copy refered cells | 16 Apr 2008 19:28 GMT | 2 |
I'm bussy summarizing a whole bunch o claims for 4 similar projects, 36 claims x 4. Now I have cells refering for let say column A to claim 1 (=C:\long adress... claim 1, $D$49) Now when I copy (pull down) the reference excel doesn't automaticaly number up the claim from 1 to 36. ...
|
| Excel gone from desktop, start menu, all programs?? | 16 Apr 2008 18:51 GMT | 3 |
Excel has left the building, it now longer shows up in my start menu under microsoft office. The only way I can open is to go open an existing sheet. Not a big deal but a little annoying... anyone have an idea how I can get it back?
|
| Selecting A cell... | 16 Apr 2008 18:48 GMT | 6 |
I am going crazy! I recently got Office 07 on my computer...it was working fine...now for some reason when I am working in excel...when I go to click on a cell, it will select the cell I want AND the adjoining two or three cells (typically three). I have tried everything that was ...
|
| Stumped | 16 Apr 2008 18:39 GMT | 1 |
I seen this formula in a cell but cannot calculate. What does it mean? =G$16*EI!$F$71
|