Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How do I use Excel to do a Gage Repeatability and Reproducibility.26 Sep 2005 03:55 GMT1
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 columns26 Sep 2005 03:48 GMT2
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 formula26 Sep 2005 03:31 GMT2
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
Permutations26 Sep 2005 03:14 GMT9
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 Question26 Sep 2005 02:00 GMT3
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 + criteria26 Sep 2005 01:30 GMT2
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 to26 Sep 2005 01:00 GMT1
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 GMT2
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 COLUMN25 Sep 2005 23:39 GMT1
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 number25 Sep 2005 23:36 GMT6
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 GMT2
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 COLORS25 Sep 2005 18:50 GMT3
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 GMT1
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 out25 Sep 2005 17:46 GMT1
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 excel25 Sep 2005 17:06 GMT2
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.