| Thread | Last Post | Replies |
|
| Search for 6 Character value | 30 Nov 2007 23:31 GMT | 2 |
Hi, I am trying to design a macro that will search for values in a column that are 6 characters long. Data is text that looks like numbers (downloaded from a mainframe). I tried using a search with 6 *'s but it just returned everything.
|
| Finding the longest contiguous 1-d array of 0's | 30 Nov 2007 23:25 GMT | 2 |
Ok, I can't think of any remotely-easy way to do this. My data exists as such: accounts listed in the rows, dates (by month) listed in the columns; in the fields corresponding to each account/dates is the quantity of items the account purchased in that month.
|
| Excel 2007, Conditional Formatting, Format Painter | 30 Nov 2007 23:19 GMT | 3 |
Hi! I had a question using the format painter in the new Excel 2007 for conditional formatting. In my "old" version of Excel, if I had a conditional format in cell F5, I could format paint that conditional formatting from F6 through F200, and the relative reference that I used ...
|
| Range Breakup | 30 Nov 2007 22:41 GMT | 9 |
I am looking for a way to break up a range into separate cells. For example, I have a range of zip codes in one cell that looks like this: 99359-99363 I would like that to break into 5 cells, with values of 99359, 99360, 99361, 99362, and 99363.
|
| Drop Down Menu Conditional Formatting | 30 Nov 2007 22:37 GMT | 4 |
I've created a drop down menu for cell I4 that allows users to choose A, B, C or D. Depending on what letter they choose, I want another drop down menu. Such as, if they choose A, I want their choices to be Apples, Oranges, Grapes. If they choose B, I want their choices to be ...
|
| Subtract from today's date | 30 Nov 2007 22:29 GMT | 7 |
I am sure this is easier than I am making it out but how do I subtract a date in cell F11 from todays date? We want to actually calculate the number of months in between the dates. Thank you
|
| Finding What Cultural Environment An XLS Was Created In: Excel 200 | 30 Nov 2007 22:23 GMT | 4 |
Does anyone know of a way to determine what cultural environment an Excel workbook was created in before opening the workbook? We tried right-clicking and looking in properties, but didn't see any property referencing the environment.
|
| Excel - Mailing List | 30 Nov 2007 22:01 GMT | 1 |
I have about 2000 names and addresses in Column A in block form. I would like to have the option to separate the name from the address Example: move address to column B so I can mail merge. Any suggestions would be helpful. Thank you.
|
| how to recover data saved | 30 Nov 2007 22:00 GMT | 1 |
How to recover data that I have been working on for the past 3 days and I save it with the picture disc save and just closed it. Now it will not show all my data.
|
| Entry into one cell clears other cells | 30 Nov 2007 21:58 GMT | 1 |
I have a series of 10 cells, and I only want to be able to select one of the cells. Therefore, if I put an "x" in one of the 10 cells, I want the cell that currently has the "x" in it to clear out. Thanks
|
| Tool bar keeps changing back after I add edit buttons | 30 Nov 2007 21:36 GMT | 1 |
I have added insert and delete rows/column buttons to my Excel tool bar - but the tool bar keeps changing back. How do I locl the trool bar to accept my changes?
|
| Need help with formula to forecast revenue | 30 Nov 2007 21:35 GMT | 2 |
{Excel 2003} (Posted this yesterday and did not get any help) Each Row is revenue by customer Each column is a month {jan-07, feb-07, mar-07}
|
| Question regarding functions | 30 Nov 2007 21:29 GMT | 1 |
Hello. I have a (hopefully) basic question on how to create a specific function in Excel. Here is a rundown of the spreadsheet I'm working with: It's a quality score tracker, so in column A there is a list of names. Column B is where I want the function to go. Columns C ...
|
| Excel links | 30 Nov 2007 20:42 GMT | 1 |
Do I have to update ALL links when opening a spreadsheet with links? Can I pick and choose which links to update? Thanks.
|
| General | 30 Nov 2007 20:39 GMT | 1 |
I'm experienced with Excel 2002 with my old computer. Is there anything lost from transfering programs to my new computer which has Excel 2007 on it? Also, is there a way to make a value in a cell generate a one time "beep" type sound if the value in the cell meets a certain ...
|