| Thread | Last Post | Replies |
|
| Needing Help Very Bad | 19 Jul 2006 07:23 GMT | 6 |
For what I need it would be to hard for me to explain. I have the sheet with note's in it. Could I maybe E-mail someone to look at
|
| Counting Values | 19 Jul 2006 07:03 GMT | 3 |
I am still having an issue with counting values: I want to count the number of values in multiple cells that meet a condition. Two of the conditions are: Greater than 6 but less than 10
|
| Converting Getpivotdata function in Excel '03 to Excel '00?? | 19 Jul 2006 04:21 GMT | 4 |
I have a tough problem I really need solving. For work I had to do a huge report with a lot of getpivotdata function from a number of pivot tables. The platform i used was Excel 2003, which I use at home.
|
| Compare two cells and return certain value in third cell | 19 Jul 2006 03:44 GMT | 3 |
Dear Collagues, Really needs your helps. My situation is I have three cell. The first cell is Product and the second cell is Hardness. My problem is I don't know how to put
|
| Excel performance calculation | 19 Jul 2006 03:37 GMT | 4 |
Could you let me know if there is an Excel function that calculates the below formula: List of percentages in column A, with the answer I want at the end of the column is as follows:
|
| Setup Purchase Order Template to have a automatic number system? | 19 Jul 2006 03:08 GMT | 2 |
How do I setup a Purchase Order Template to have a numbering system? I would like to setup a purchase order template with a numbering system that when each time we open new file the Purchase Order will change number. i.e., start at: W400001, next number W400002 etc.
|
| I have to change a bunch of formula that need to reference a different workbook. | 19 Jul 2006 02:56 GMT | 5 |
The one workbook will have a price list the other will have all the quote sheets. At first I had a page with the mark ups and hourly rate in the first workbook that they were used on another page to mark up the products. But I realized that this wouldn't work because an changes in ...
|
| Help needed | 19 Jul 2006 02:36 GMT | 5 |
one of my friends asked this question and i did not have an answer so posting it here. I want the work book to be shared by mulitiple users. Each user should have a tab dedicated to them. Apart from the administrator nobody should be able
|
| Complex Date Formula | 19 Jul 2006 02:14 GMT | 2 |
Working on a sheet that I need date calculations formulas. 1.) Need it to calculate the difference between two dates. (Pretty much have this one nailed) 2.) Once the calculation is made I need for it to give me a value back
|
| How do I calculate times each word occurs in a column of cells? | 19 Jul 2006 01:30 GMT | 3 |
Rather than use a complicated array formula, is there a simpler way to determine how many times a particular word occurs in a range of cells in a column? Thank you.
|
| Split a Cell? | 19 Jul 2006 01:18 GMT | 6 |
I have a column "A" with data like the following: 6/12/2006 9:30 I would like to split this into two other columns like: COLUMN B | COLUMN C
|
| highlighting problem in excel | 19 Jul 2006 00:32 GMT | 1 |
I am experiencing problems with highlights in a previously saved excel spreadsheet. they have disappeared and now I can't highlight any cells at my terminal. if i open my spread sheet on another terminal the cells show the highlights. is this an excel problem or a computer
|
| Extract Date from Right Formula | 18 Jul 2006 23:41 GMT | 3 |
I need a formula that will extract the last date from these type of strings. 07/12/200607/12/200607/12/200607/17/2006- - Or
|
| Workday calculation - not working | 18 Jul 2006 23:31 GMT | 5 |
I'm trying to make a time and events schedule to track a project's progress. basically in A1 will be the start date, B1 will be the end date, and I want to know the number of workdays, not including weekends it will take to complete this part of the project in C1. I've entered ...
|
| Data validation | 18 Jul 2006 23:05 GMT | 5 |
In data validation I'm trying to refer to a list in a different sheet but I didnt work. I have followed the help function in Microsoft but I keep getting the message that in data validation you cannot refer to a list in a different workbook.
|