| Thread | Last Post | Replies |
|
| Excel formula to return all non-blank values | 14 Feb 2008 22:54 GMT | 2 |
I am trying to figure out an excel formula to help me return all non- blank values from one column into another. I'd like it to look like the below example. All values from column A listed sequentially in Column B with no blank spaces.
|
| Text overalps gridlines | 14 Feb 2008 22:43 GMT | 3 |
Recently, anytime I print out an Excel spreadsheet with gridlines, the text entered starts overlapping the gridlines. I'm using Microsoft Excel 2002 and printing to a networked printer (HP LaserJet 4Si) and yes I've tried deleting the printer and re-adding it on my computer but ...
|
| Help Please VLOOKUP question | 14 Feb 2008 22:35 GMT | 2 |
I am having trouble with the syntax of a VLOOKUP argument. I am using Excel in Office XP My unique column of numbers (the vlookup) value is a variable. I want it to look up values between 1230000000 and 1230099999.
|
| viewing data | 14 Feb 2008 22:19 GMT | 3 |
I'm not sure I'm going to make sense with this question, but here it goes: I have a spreadsheet with data on multiple subjects for multiple people. Is there a way to freeze the window, or split the document, in multiple places so I can see each subject and scroll through the ...
|
| How can I seperate numbers from text (in one cell) into 2 cells? | 14 Feb 2008 22:14 GMT | 2 |
I have data in this form in ONE CELL 20040 - Selling Expenses I would like this data in TWO cells: [ 20040 ] [ - Selling Expenses ]
|
| math problem | 14 Feb 2008 22:08 GMT | 2 |
i want to find 3√8 ... how do i enter this in excel
|
| math problem. | 14 Feb 2008 21:58 GMT | 3 |
i want to find 3√8 ... how do i enter this in excel ... The answer is 2. but i want to be able to setup more complex equations. Thanks for the help
|
| Macro "disable or enable" screen | 14 Feb 2008 21:53 GMT | 2 |
When I start up an excel file a message comes up that says this file contains a macro. How can I find it to delete it. I tried to make one when I first started on it but then decided not to. I deleted everything that I could fine. Any suggestions on how to get this to go away ...
|
| Return column number from column header text | 14 Feb 2008 21:40 GMT | 4 |
Excel 2003 I need to return the column number from a worksheet by searching on the text in the column headers. Example:
|
| Dragging to select multiple rows causes out of control scroll | 14 Feb 2008 21:19 GMT | 7 |
When I select a number of rows by click and drag method, the rows scroll by too fast to control. Is there a way to slow down this scrolling?
|
| Create Status Chart for projects | 14 Feb 2008 21:07 GMT | 4 |
I need to create a status report for about 10 project that my group works on. But we don't have any sort of measurement tool like budget or % complete. All I have is the listing of projects and it's Green, Yellow or Red. Is there any way to put them in bar or pie chart. ...
|
| One cell isn't recognized? | 14 Feb 2008 21:07 GMT | 2 |
Orginally, I had some formulas pull some data over from another spreadsheet, for some reason on cell was not being recognized. I have a total at the bottom for the column. So, I copy and pasted the values and still no total.
|
| Excel changed into Word | 14 Feb 2008 21:03 GMT | 4 |
Every time I opened certin excel files it would say it was created in an old excel and I may lose stuff. I always said ok and nothing was lost. Today I said to do a save in some other format (unfortunately I wasn't paying attention and don't remember what) and now all my excel ...
|
| Search for Upper Case | 14 Feb 2008 20:59 GMT | 4 |
How can I search in a cell for any letter in a word that may be upper case? For example I want to identify that a cell has a word such as ibuPROfen.
|
| Excel 2007: How do I create a hovering (detatched) toolbar? | 14 Feb 2008 20:37 GMT | 3 |
In Excel 2003, you could create a custom toolbar, then detatch it so that it hovered over your spreadsheet, no matter where you navigated. I want to duplicate that in Excel 2007.
|