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 / February 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
i think i need goal seek or other type of statistic function08 Feb 2007 11:39 GMT2
difficult to explain without drawing a picture, but i need to figure out
future "x" values with given "y" values and also with a given line.
the "y" axis =
1,000,000
Could anybody tell me how to add values based on dates.08 Feb 2007 11:00 GMT1
I want to get the sum of a particular month E.G. 1 Jan 07 to 31 Jan 07 from 6
months data?
ranking08 Feb 2007 10:53 GMT6
I have a table which looks like this
PERCENTAGE    PLAYED    WON    LOST    DRAWN    TOTAL SCORE
70.0%    5    3    1    1    10
50.0%    5    2    2    1    7
Wrong result on dividing 2 values08 Feb 2007 09:58 GMT1
On Sheet 1, I have a cell  E9 with a value is calculated by linking to a
value in Sheet2. The formular in cell E9, Sheet 1 is look like this
=('Worksheet2'!H13*0.1).  The value in Cell H13 sheet 2 is $289.79 multiply
by 10%.  The formular gives me a correct result in Cell E9, ...
Times in Excel08 Feb 2007 08:44 GMT6
Hi
I am trying to calculate number of hours between 2 times.  I am helping
someone in a hospital. If a patient checks in at 18:00pm and checks out at
03:30am - how can I calculate the number of hours they were in the hospital.  
Why security warning still appear after I delete all macros08 Feb 2007 05:51 GMT1
Hi, I keep receiving security warnings everytime I open a workbook that
previously contained macros. I have deleted all macros and I can't find
anymore macros left. Visual basic code also appears to be empty. Is the macro
being stored at somewhere else? Is there anyway that I can ...
averaging with conditions08 Feb 2007 05:16 GMT5
A1    Height1      Height2     Height3    Height mean
B1     157.6          157.7         159             ?
I need a formula that will average the two closest figures and ignore the
third figure.  eg Height 1 and Height 2 are closest therefore average these
The '" -- " before a function08 Feb 2007 04:14 GMT4
What is the name of this symbol and what is it do when placed in front of a
function name.  ie.  --isnumber........
Thanks
How do i automaticaly number consecutive forms08 Feb 2007 03:02 GMT2
I need to generate consecutive forms and number them for future reference, to
run on Excel 2000 and 2003.
Help with Lookup(), VLookup08 Feb 2007 01:06 GMT6
I have some data in one sheet similar to this:
100.0  2.2
200.0  3.1
300.0  1.9
sorting through unknown source data as it is entered08 Feb 2007 01:03 GMT1
If Worksheet1! column A is designated for names and column B is for #sales,
but NO data has been entered in either columns yet, Can I have another
worksheet (Worksheet2! column A & B) create a running list of how many sales
each employee makes to date?
Counting Match Fomulas?08 Feb 2007 00:37 GMT2
I've got a few sheets in my workbook.  
One sheet (titled Open Documents)I have imported from another program which
tells me document numbers, titles, originator or responsible person (this
column lists multiple people in one row), dates opened and closed, type of
Nested IF statements08 Feb 2007 00:17 GMT4
I want to evaluate a cell reference to determine if the amount is <= 2400.
If the amount > 2400 then multiply the amount by .25
If the amount <= 2400 then subtract 265 and multiply the difference by .25
Using Formula based Cell Content Return Unique Consecutive Duplicate Values 07 Feb 2007 23:33 GMT8
I have a Named Range called "Data" that spans 8 columns and 7 rows. A Numeric
Value will appear only once in a row. Each row's Numeric Values are in
ascending order. A unique consecutive duplicate MUST be in the SAME column.
I would like to Return Unique Consecutive Duplicates ...
The Kth element in a text list07 Feb 2007 22:59 GMT15
=Small(A1:A5,2) from
12
15
12
 
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.