| Thread | Last Post | Replies |
|
| changing text in multiple cells by pattern | 19 Feb 2008 08:53 GMT | 4 |
I have excel workbook which contains column of cells with web adresses(as text, not hyperlinks), which lead to *.jpg files. All the web links have the exact same adress, except the jpg filename, for example: http://www.microsoft.com/pics/1.jpg,
|
| Printing XL Sheets name | 19 Feb 2008 08:23 GMT | 1 |
I have many sheets in my EXCEL file (Excel 2000). How can I print all the sheets name only, not the contents of sheet ? is there any function or trick ?
|
| what formula best divides sales of a company with 25 members | 19 Feb 2008 08:20 GMT | 1 |
NEED HELP TO PLAN THE DIVISION OF A COMPANY WITH 25 MEMBERS.ALL HAVE BEEN PART FOR DIFFERENT AMOUNT OF YEARS.
|
| Tracking High Frequency Occurences | 19 Feb 2008 06:04 GMT | 4 |
I am trying to track the most frequently occurring statements on a sheet. For example: Column A Column B People Apples
|
| Formula query | 19 Feb 2008 05:34 GMT | 1 |
Hi, I want to track expired training competencies by totals eg: +90 days, +120 days, etc I currently track current competencies with the below formula but i am not sure how i would modify it to read the same range of cells but for
|
| Password protection | 19 Feb 2008 05:13 GMT | 5 |
I need to protect 3 sheets in a workbook from being unhidden. I know Excel has the password protection at the time you open and the worksheet protection. I also know there is a large number of products that can break these.
|
| Formula for coinciding columns... | 19 Feb 2008 03:14 GMT | 4 |
I have 3 columns, the first one has project numbers, the second one has dates, and the third has my formula. What I want the formula to do is for any project number that is the same in column 1 and has all dates filled in for those projects to show "complete" in the third column. ...
|
| Saving from Excel to MS Office Drawing Object | 19 Feb 2008 02:53 GMT | 4 |
How would I save a selected range from an MS Excel worksheet into a MS Office Drawing Object - the picture format that can be easily rotated in MS Word. Unfortunately no other picture formats will substitute... Thanks!
|
| how to make a shewhart chart | 19 Feb 2008 02:45 GMT | 3 |
working on a QA,QC project for a start up lab and I need some pointers on stats, as well as how to construct these specific types of charts.
|
| how can i count the number of unique names in a list | 19 Feb 2008 01:36 GMT | 6 |
I hace a list with multiple same names. in excel how can i count each name once for a get a list total . I tried most of the count function and can get them to work. smith
|
| Unwanted instance od a window | 19 Feb 2008 01:05 GMT | 2 |
MS Office 2003 on Win XP I have a simple WorkBook with several (spread)sheets; no macros. The file is called MyFile.xls. When it's open, and I click Window on the menu bar, I'm given a choice of 2
|
| Validation | 19 Feb 2008 01:02 GMT | 1 |
if e3 < b3 then validation message. How would I write this formula for the validation message to work. Thanks in advance
|
| how to find date and time of each cell ? | 19 Feb 2008 00:58 GMT | 2 |
Does anyone know if there is a way to find out when each cell in the excel was made/changed ? date and time? maybe there is a program for it or software? please let me know at mikerush7@yahoo.com
|
| Results different when using linked worksheets | 19 Feb 2008 00:50 GMT | 2 |
When I multiply values contained in a single worksheet i get one set of results, but when I multiply the same values linked across 2 worksheets, the results are different. What would cause this?
|
| Macro and row protection | 19 Feb 2008 00:05 GMT | 1 |
I need my macro to return me to col A in the current row no matter what column I am in. I have tried this with "Home" but when I run the Macro a second time from another row, I return to col A in the row above the row I was in when I ran the Macro the first time.
|