| Thread | Last Post | Replies |
|
| Adding more information to a column of cells? | 16 May 2008 15:13 GMT | 2 |
Is it possible to add more to a cell? For example, I have one column of cells numbering from 1 to 10. I want to add a prefix or suffix to the number therefore I get: 1rabbit
|
| Vlookup or Index/Match | 16 May 2008 15:12 GMT | 3 |
I have a worksheet of data (cells named PV_Data), extracted from a d/ b, column A contains a "week commencing" date (cells named "Week_Of") and column B contains a list of names (cells named "Resources"). I have a second worksheet that I am trying to populate based upon the
|
| Selected cells do not show animated border | 16 May 2008 14:52 GMT | 5 |
When selecting non adjacent cells with CTRL button and cursor the cells are not being highlighted with flashing dashes like they used to. where can I look to turn this feature back on?
|
| Results into one cell | 16 May 2008 14:47 GMT | 1 |
I am trying to put the results of 3 cells into one cell. Here's what I am trying to do: e7 will equal either "" or 30, f7 will equal either"" or 36 and g7 will equal "" or 48. When any one of the cells has the appropiate number in it, 30, 36, or 48 the other two cells will be
|
| Is graphs goal seek still available in Excel 2007? | 16 May 2008 14:43 GMT | 1 |
If it is I can't find it! I can use goal seek on the source data, but I would like to use it within graphs as well.
|
| Chrt Line formats | 16 May 2008 14:39 GMT | 2 |
I have a monthly report, in which I bring in information from different work books. In the compiled workbook, I have quite a few charts in which I like to show lines with a certain format that is consistent across the sheets. e.g., line 1 is aways solid blue with solid blue ...
|
| Excel fails on Save/Save As | 16 May 2008 14:36 GMT | 11 |
I have an Excel application that I took over writing from another programmer who left the company. It's a full app -- not just a bunch of spreadsheets. Excel will frequently fail on a Save or Save As. So I go back to the
|
| How to show the figure of the filtered records ? | 16 May 2008 14:34 GMT | 1 |
Sometimes the total number of filtered records can show in left hand corner of the Excel spreadsheet but sometimes it just show the word "Filter Mode"
|
| Is there any formula like delete if? | 16 May 2008 14:12 GMT | 4 |
I need a quick help in sorting out data. I have a list of thousand email ids in each cell of the column A and among them i need to delete data in some cells where a criteria matches. Something like if the list has @xyz.com the entire value of the cell should
|
| Value must be entered | 16 May 2008 14:10 GMT | 1 |
Is it possible to require a value to be entered into a cell, and give a warning if no value is entered? Is it possible to prevent someone who is entering data in the form from moving to the next cell until this required data is entered? Thanks for your help.
|
| I am looking for an Excel document and I can only find shortcut to | 16 May 2008 13:54 GMT | 1 |
I can only find shortcut to my document. When I click on the shortcut, it will not open. Where can I look for document that will open?
|
| autoshape color conditional formating | 16 May 2008 13:35 GMT | 11 |
I'm trying to have an autoshape turn either red or green dependent upon the value in two other separate cells. Example: if A1 > 0 or if B1 > 0, the make the autoshape green otherwise, make the autoshape red.
|
| Extracting top performing products by region | 16 May 2008 12:42 GMT | 3 |
I have to analyse different products being sold in different regions, the data are tabulated by products and by region. I have to extractthe best selling product by region and overall. The table is as follows:
|
| Populating listbox with sheet names | 16 May 2008 12:33 GMT | 1 |
Can I populate a listbox with worksheet names but skip the first sheet (sheet1)?
|
| Hyperlinks | 16 May 2008 11:55 GMT | 3 |
I've created a multisheet workbook for audit planning. Each worksheet has the same 30 or so rows (subject of audit) and columns (weekly dates) and each worksheet is named for each part of the business. Each cell has a drop down list (the same for each sheet) to detail which of ...
|