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 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
SUMPRODUCT PROBLEM11 Sep 2006 05:00 GMT3
Assistance much appreciated
My worksheet as follows
col A    col B    col C        col D    col E
Name    Club    Age Group                   Place    Points
Need help with this11 Sep 2006 04:35 GMT1
Prepare a plot that shows the distribution of noise in the raw DMA data
set.  To do this, you will need to establish a set of bins to
accumulate the number of observations for a range of intensity values.
For the intensities in DMA.txt, use bins that range from 2.7815 -
sumproduct to count two arguments11 Sep 2006 03:18 GMT7
I have an excel test so please bear with me that what I am asking for
may not be the best way to do this.  Here is what I have been asked to
do.
I have daily dates from the beginning of this year to now and
Multiple Find and Replace in one function11 Sep 2006 03:16 GMT4
I'm wondering how I can clean one column of text using multiple find
arguments.  This is what I have so far:
=MID(B3,1,FIND(" Corp.",B3,1)-1)
In addition to " Corp."  I want to remove " Inc.", " Co." and a couple
data sort/filter11 Sep 2006 02:53 GMT3
I have rows of numbers from which I would like to extract the five lowest
values from each row, compute the average and display the answer in a
different column.  How can I do this?
Any help will be greatly appreciated.
How to chose bold text in a sentence in Excel?11 Sep 2006 00:46 GMT1
I have a text in a cell
Barcelona vs Osasuna  ("Barcelona" is bold)
Now I want to chose the text "Barcelona"
How to do this ?
How do I calculate an average by a certain percentage?11 Sep 2006 00:33 GMT1
My husband is a junior college teacher and needed to know how to calculate an
average by a certain percent. Say if homework was 20% of their total grade,
how would he write the formula for that?
AVERAGE function11 Sep 2006 00:31 GMT8
Can anyone tell me whether there is a way to average a whole column of
numbers but ignoring blank cells or cells with errors in
e.g.
Column A
Avoiding counting the same cell twice10 Sep 2006 22:35 GMT2
Please help, I'm stuck.
How can I count the number of cells containing certain words but avoid
counting the same cell twice.
E.g.
inserted a comment10 Sep 2006 22:24 GMT1
When I click to insert a comment my name doesn't come up in the box anymore.  
Therefore no one knows who put in the comment.
Searching and matching in sheet (urgent)10 Sep 2006 21:54 GMT1
I have the following problem .. and I can't find the way to solve it.
this is my screencapture of excel table:
http://www.fuchka.info/tmp/excelproblem.jpg
What I need is function that will:
Need help wiht a macro for autofill rows10 Sep 2006 19:47 GMT9
I have a spreadsheet that has 10915 lines.  I am copying the same formula
from row 2 - columns H2..L2 to the next 21 rows then there will be one blank
row and I will copy the same columns for the next 21 rows - blank row again
and so on.
Re: Sum every other 5th cell10 Sep 2006 19:39 GMT4
Is it possible to Sum every 5th cell in a range of cells (i.e.
L8+L13+L18+L24....in a range of L1: L45) without entering every cell
manually?
From cell L8 and every 5th cell until cell L45.
#N/A in calculations10 Sep 2006 19:33 GMT6
I'm trying to work around some #N/A values in calculations.  Columns A and B
are populated with a conditional formula, and I'm trying to sum them in
column C; so data could look like:
A1 = 3,       B1 = 4         C1= sum(A1:B1)
why don't my functions in paste special work?10 Sep 2006 17:33 GMT2
I am trying to copy from one workbook to another workbook and keep the column
widths, print settings, etc the same but when I copy using different
functions in paste special nothing changes in the new workbook except the
visual data is present.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.