| Thread | Last Post | Replies |
|
| deleting multiple === signs to get single = | 16 Mar 2008 20:41 GMT | 1 |
When I type the equal sign I get multiple strikes. How can I eliminate that problem
|
| one click move | 16 Mar 2008 20:04 GMT | 1 |
I am trying to design a spreadsheet for tracking inventory. I need to establish a formula that will allow me to enter a single digit into a cell and then move to the next cell without having to hit the enter key. The digits will always be one digit and numeric. I appreciate ...
|
| Text to Columns Question | 16 Mar 2008 17:59 GMT | 3 |
I have text in a column that is similar to this: "Last Name <two spaces> firstname<Space>Initial" and possibly a spouse name and initial on the end of that. My goal is to get the last name in a separate column. I want to use the
|
| Macro Range Selection | 16 Mar 2008 17:38 GMT | 3 |
The the range select below I would like to be able to start the cursor in any row and have it select columns A:C Range("A16:C16").Select Thanks for any assistance
|
| formulas in cells change when using filter function | 16 Mar 2008 15:23 GMT | 2 |
column L uses a 'countif' formula to determine the number of times a specific # appears in column F. after formulas were entered, i filtered the data, and the range for many of those formulas changed. how do i fix this?
|
| Excel 2003 serious error | 16 Mar 2008 15:19 GMT | 5 |
Hello I am new to this forum. I did try to search for my problem prior to posting, but did not find anything. I am having a major issue on one of the computers in my company. A co-workers excel 2003 opens and starts opening a whole bunch of files automatically, most of which are
|
| Excel merge or synchronize | 16 Mar 2008 14:40 GMT | 2 |
I have a client with 2 Excel 2007 documents. Let’s name then excel1 and excel2. Now the client has always worked in excel1. Recently however the client suffered a system failure and excel1 was lost. Excel2 is a backup copy of excel1, but it hasn’t been backed up for more than 2 ...
|
| Sorting Data Advice please | 16 Mar 2008 14:35 GMT | 2 |
Assuming I have 20 Columns or more with headers. Column C has a date field, and I have define a name for it "Date" relevant to each row. I want to sort all the rows in date order.
|
| How do I carry format into word using mail merge? | 16 Mar 2008 14:17 GMT | 1 |
I am trying to carry a dollar amount into word, it is in excel, and the cells are formatted for currency. it appears as $1.50 in excel, but 1.5 once merge it to excel.
|
| Can anybody help on macro please? | 16 Mar 2008 13:22 GMT | 8 |
Does anyone have any suggestion on how to load a web link by modifying following codes? Please see the coding at the bottom. Instead of a list of file names on column A under Lists worksheet, it is a list of web links on column A under Lists worksheet.
|
| Circular References | 16 Mar 2008 13:09 GMT | 2 |
I have a csv file saved in 2003 on a laptop. The laptop is the office laptop and when I am home, I access my home network from that laptop using a wireless that is, in a sense, in a DMZ for a Small Business Server network. I log into the home network using an RDC over VPN. The ...
|
| Nested "If Statement" | 16 Mar 2008 12:43 GMT | 4 |
I am trying to write a "Nested If Statement". The purpose is to pick the correct grade if it fails within a cetain range. I have dont everything write. However, I discovered that I cant write more than 7 statements.
|
| simple dates & Filtering question?? | 16 Mar 2008 11:55 GMT | 2 |
i have a column with dates (dd/mm/yyyy) i formated the cells to dates. then i filtered them from the drop down box to Acsending. the problem is it orders them first in dd wise then mm wise then yyyy wise
|
| Formula Help for Duplicate Entries | 16 Mar 2008 09:05 GMT | 1 |
I have a spreadsheet of 3000 contact names I am trying to assign these in the most "fair" fashion to account resps. My thought was to create a colum called "account_rep"
|
| how do i transpose a Polynomial equation from a graph to a sheet? | 16 Mar 2008 07:40 GMT | 2 |
I have produced a polynomial trend line in a graph. I now want to produce that curve but the equation provided on the graph does not produce it. Is it possible for Excel to produce that equation for me directly onto a sheet and thus enable me reproduce the curve so that I can ...
|