Summary: I have created the excel file in excel 2003 and transfered it to excel 1997 in my 2nd computer. However when i tried to save the file in excel 1997, i...
Summary: I have a Parts spreadsheet that I want to be able to fill in the first column in a row, which is the part number, and then it automatically fills in t...
Summary: Could some one please tell me how to construct a macro, in excel, to delete rows that in a collumn aren't multiples of 300. Thanks in advance ...
Summary: Hi, As I mentioned an alternative and more specific approach is to use a Macro. The following code can be attached to a command button on your summary...
Summary: I am using the Data-filter-Auto filter function to filter data based on 3 different criteria in Excel. Then I need to summarize one row of data. Thi...
Summary: Hi, From your post, I thought that you were familiar with conditional formating formulas, which is why I didn't provide any instructions for using it,...
Summary: Assuming your data is already sorted so that the duplicates follow one another as in your example, try this code: What it does is check each item in c...
Summary: Hi, I need to calculate how many times 2 specific characters appear in the same cell throughout an entire spreadsheet of about 98 columns and 98 rows,...
Summary: I have created a spreadsheet which has a template form so that when information is added into an input sheet it links into the relevant section within...
Summary: I have a table in excel with some calculated figures. I use the function to round the figures to 2 decimal places. However, when I merge the figures...
Summary: Here's what I want to do: From: A B C I want it to become: A A (selected row) B B (selected row) C C (selected row) How do I do this? Here is my draft...
Summary: Is there any way to assign a comment to a value instead of a cell? for instance have a name from a drop down list but when you hover over the name sho...
Summary: I have a company that sells virtual servers to users on a monthly basis. Payment is made through subscription on paypal by all our users. Right now I...
Summary: Hi, First a quick background on dates in Excel. Excel holds dates as numbers, starting with 1 for 01 January 1900 25 November 2009 is 40142 Excel also...
Summary: I have an extremely simple Excel spreadsheet that I use to keep track of my running. It's columns are: Date, time to run a mile, time to run 2 miles, ...
Summary: Hi Guys - Is it possible to utilise the indirect function or a means using VBA to populate the listfill range of a combobox - this is also referred to...
Summary: I need to take time from a stopwatch (00:00:00 = min:sec:hundreths) and divide it into an hour. Cell F8 (load time - 04:56:10), Cell F10 (run time - ...
Summary: I have a user who was using Outlook 2003 on Windows XP SP3. She has some distribution lists (DL) in her Contacts folder with a lot of entries. Most ...
Summary: In column A I have a list of items that all start with an A (a1 a2 a3 etc) In column B I want to use “lookup” to generate a sales report from anot...
Summary: Excel Data Validation: The following Formula will determine if the data entered into a cell (D3) is a Capital "Y". If so it will allow it, otherwise r...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
