| Thread | Last Post | Replies |
|
| How do I use Excel to do a Gage Repeatability and Reproducibility. | 26 Sep 2005 03:55 GMT | 1 |
How do I find the Gage R and R templates? Everyone at work and in my class has them built into their version of Exce.
|
| sharing entire columns | 26 Sep 2005 03:48 GMT | 2 |
I need to have the following lookup table work within multiple sheets. sheet 1 cell c5 ( has a pulldown with 9 different values) cells c10:c20 (blank cells needing values relative to value put in c5)
|
| Insert New Row without shifting formula | 26 Sep 2005 03:31 GMT | 2 |
e.g. I have a formula in cell B4 that calculates data in column cells C4 to, say, M4. (e.g. "=Sum($C4.$M4)") I then wish to insert a new C4 row, copy a new set of data into the new C4, but use the same formula in B4 to calculate the new totals ("=Sum($C4.$M4)"). However, when I
|
| Permutations | 26 Sep 2005 03:14 GMT | 9 |
Can any one give me the formula for doing permutations ie. odds against picking 6 numbers, not in numerical order, from 45 numbers. Excel's PERMUT function for =Permut(45.6) returns odds of 5,864,443,200 This seems too excessive, it's more like the odds of picking the 6 numbers
|
| Excel 2000 Question | 26 Sep 2005 02:00 GMT | 3 |
if,then statement returns a false because alpha string is more than 5 characters. Example: =IF(C6="Travel","True","False") and cell 'C6' does equal "travel". It works
|
| count cell if value present in every other cell + criteria | 26 Sep 2005 01:30 GMT | 2 |
I have a spreadsheet where I am trying to count the number of cells that have a value in them. this is for counting raw material on either skids or metal coils that is in inventory. Here is what I am trying to do:
|
| VLOOKUP - computed go to | 26 Sep 2005 01:00 GMT | 1 |
I use the serial number date as the 'find' part of Vlookup in anothe worksheet which is sorted properly by date. I place at the head of th column the date I want selected and use a concatenate to try and ge the Vlookups in the column to go to a different date on the remot
|
| SUMIF problem... | 26 Sep 2005 00:17 GMT | 2 |
My scenario I have a sheet that shows points scored by various teams in a championship across several weeks Each team has two team members
|
| HOW DO YOU ADD & SUBTRACT IN ONE COLUMN | 25 Sep 2005 23:39 GMT | 1 |
How do you subtract and add in the same column going in the decending order? I have a worksheet and we need to subtract some and add others. How does this work?
|
| Conditional format of minimum number | 25 Sep 2005 23:36 GMT | 6 |
I have a column of numbers that are the results of a formula (common to each row). What I would like to do is apply a format to the cell that contains the minimum value in the column and to the max value as well. I can use the MIN or MAX formula to place the value in a remote cell ...
|
| Pivot table page filter not accepting multiple values. Workaround? | 25 Sep 2005 21:35 GMT | 2 |
I am trying to make a pivot table where I need to filter the data by the values in a certain data field ("field 1"). I need to allow records with either "this or this or this" value in the field 1. The problem is that the pivot table page filter only allows for one single value ...
|
| I TELL A CELL =B1 BUT I ALSO WANT IT TO TAKE THE TEXT COLORS | 25 Sep 2005 18:50 GMT | 3 |
I have a woorkbook that has a list of movies, all in column A. In the rest of the columns I use =A9 and so on. The info goes to the cells just fine but I would also like it to take the color of the text! Is this possible?
|
| Traffic needed. Can anyone help? | 25 Sep 2005 18:06 GMT | 1 |
Hey everyone, I'd like to ask your advice, or at least the advice of all of you who are either interested in, or already involved in, creating income from the internet. I'm not exactly experienced in on-line money making, in fact all I've managed so far is money losing! I don't ...
|
| Advanced Filter is grayed out | 25 Sep 2005 17:46 GMT | 1 |
Why can't I use this? Autofilter works fine. I've carefully gone through help to set up the table and criteria range correctly. Excel 2003 SP1. Any help will be appreciated.
|
| Permutation in excel | 25 Sep 2005 17:06 GMT | 2 |
Hallo everybody! I´ve a vba code now that can generate combinations in excel but when it will com to the end of the rows, that means 65500(or something like that), I have built in code that order it to cintinue on another
|