| Thread | Last Post | Replies |
|
| IS there a way to find the name of GIF file over Excel cell | 15 Dec 2005 02:09 GMT | 1 |
Please help, please!!!! Is there a way to find the name of GIF image over a sheet cell. these images are small tick marks and I need to store the count of these images into each respective cell. There can be upto 3 GIF images at the
|
| Need Help with a Date Sum Product | 15 Dec 2005 01:14 GMT | 3 |
I have attached a small worksheet that explains my two problems. My first problem. In one column I have various dates entered, in the next column are numbers. What I need to be able to do is based on a start and end date, I need to find all the data within the date range.
|
| Sharing sheet | 15 Dec 2005 00:52 GMT | 2 |
I have an excel form with 2 sheets. My excel form is sharable (for 30 users). My question is : How to share my sheets, like this way when the user 1 who's working on
|
| Making this formula work | 15 Dec 2005 00:42 GMT | 4 |
Based on a question in a different forum, I was trying to see if I could figure out the answer using some of the new techniques I've seen on these forums. I wrote the following formula, which I can't seem to get to work, although using F9 to calculate parts of the formula seem ...
|
| Combine information about products from 2 spreadsheets | 15 Dec 2005 00:38 GMT | 1 |
Hi Everybody, thank you in advance for your help :) I am trying to two seperate spreadsheets into one. The spreadsheets are two different versions of the same list. One is older and one is newer. The spreadsheets look like this.
|
| How do I search excel spreadsheets using multiple search criteria. | 15 Dec 2005 00:26 GMT | 4 |
I am trying to extract data from a spreadsheet using a search function that has two search criteria. For example, I have a worksheet filled with employee performance data and need to extract data to a table based employee name AND date. Something similar to VLOOKUP but with two ...
|
| Find and Replace | 15 Dec 2005 00:25 GMT | 3 |
Is there a way to use the "find and replace" function to find and delet words? I have a spreadsheet that has a column of cells with produc descriptions in them. Each description contains the manufacturer' name, which I don't need. I did a find and replace of the o
|
| Checking for a zero value in multiple columns | 15 Dec 2005 00:25 GMT | 2 |
I have created a spreadsheet to track my investments. Each year is on a separate tab in the worksheet. I would like to use a formula to calculate my total gain/loss for the any given year including the current one. How do I get Excel to check each month starting with the end of ...
|
| Wrap Text | 15 Dec 2005 00:25 GMT | 1 |
I have one cell that will not wrap text. it does not have that much text in there. The check box is checked in the formating section. Other cells are wrapping except this one? Any suggestions?
|
| Macro - Delete Comments - What if there's none? | 14 Dec 2005 22:56 GMT | 1 |
I inserted the Macro below into a series of macros. If there is(are) NO comment(s) in the worksheet, my macros will not run properly. Please edit my macro so if there is(are) NO comment(s), the rest of the macros will still run.
|
| How do I Find links in worksheets - not in any formula | 14 Dec 2005 22:41 GMT | 3 |
When I open the Excel 2000 file, I am asked about links I no longer want. I have tried to find these references in the worksheets so I can delete them but have not been successful..
|
| Keeping Control Buttons Still | 14 Dec 2005 22:41 GMT | 1 |
I have created an interface sheet with a number of control buttons on it. I do not want the buttons to move or change size. I have set the properties to "Don't Move or Size with Cells" and have the "Print" box unchecked. The control buttons still move if the one of the ...
|
| If, but, and still but, all in one formula? | 14 Dec 2005 21:56 GMT | 2 |
I've also been playing with this, trying to use either IF, or SUMIF, or SUMPRODUCT, trying to make this work (adding B+C, compare with D, and determine if the sum is =, <, or >, than D, and giving the result in E):
|
| Can I add a graphic to a cell in Excel | 14 Dec 2005 21:55 GMT | 2 |
I want to add a graphic such as a signature to a cell in Excel so that it can be used in a merge document. Is this possible.
|
| Multiple Count Criteria | 14 Dec 2005 21:47 GMT | 1 |
Which function do I use to count all of the rows that have both the numberical value >0 in column C AND the words "Star quality" in Column L?
|