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 / December 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
STDEVPA question12 Dec 2005 04:55 GMT2
I need to run a standard deviation STDEVPA on rows of numbers from a table of
data. I need to lookup a reference and then return a row of numbers right of
that reference to run the STDEVPA on. VLOOKUP doesn't do it since it can only
return one cell value. Does anyone have an idea ...
match and if then12 Dec 2005 04:44 GMT1
if some one has a little time would you please email me, and see if you
can help
Signature

Teerings3

Find percentage ???12 Dec 2005 04:40 GMT3
How do I find percentage of a number...
say..
A1 = 100
A2=  60% of A1 (100)
Not Sure if HLOOKUP, VLOOKUP or LISTLOOKUP..Help!12 Dec 2005 04:31 GMT2
I have a spread sheet that has the following cells:
A1 is a material dd list of slings (rope, wire rope, synthetic web)
B2 is a material type - if rope is selected in A1 then in B2 you only get
types of rope, if wire rope is selected, you only get types of wire rope, etc
How do I change my typing from horizontal to vertical12 Dec 2005 03:18 GMT2
I am making  a chart and I do not know how to make some of my boxes go from
horizontal typing to vertical.
Copying Formulas12 Dec 2005 02:37 GMT7
How do I copy a formula from a group of cells to another group of cells
without excel editing the formula?
For example, I want the exact same formula from one group copied to another
group - as is - without any changes to it at all.  For example, I am using
Dynamically-linked formula, cell reference in the string12 Dec 2005 01:36 GMT4
I have a series of formula which use the same condition.
Eg:
C1 contains the string of the testing condition, [eg IF(AND($D1=$E1, $F1=0),
"", ]
I need to consolidate data from 3 different worksheets?12 Dec 2005 01:04 GMT1
I need to consolidate data from 3 worksheets, each having 4 rows of reference
information, that will calcuate the average of all 3 worksheets onto a 4th
worksheet.  How do I do this?  I have to use Excel spreadsheets.
Today's Due Date in Colour11 Dec 2005 22:20 GMT2
Please help.
I have a column called "Due Date" I will like every morning, to have all the
dates that are due the current day (()Today) to be highlited in red. Can
this be done, if so how?
YIKES! All Validation functionality DISAPPEARED!11 Dec 2005 22:11 GMT3
Help Please!
I'm not sure how this happened!  I had various cells in my worksheet with
validation functions/drop down menus.  The reference lists are still there..
but the arrows and menus within the cells disappeared!  Not only that, but I
Yes, No, N/A in formula11 Dec 2005 22:10 GMT2
Here is a formula that was provided to me.  It works great.  However, after
reconciling my data I found that some cells in column K will need to have a
N/A vice a number.  Therefore, the below formula (in cloumn C) is reading the
N/A and providing a false "No".  Actually if there ...
Conditional subtotals11 Dec 2005 21:10 GMT10
I have a subtotal question
Let's say I have this set of data
A..................B..........C
date_______amt_ sub
add data to combo box in excel then invoke macro11 Dec 2005 20:50 GMT1
I want to either add a combo box or using data validation creat a list of
peolpes names. I will create a worksheet with each persons name and use the
result of the combo box or drop down list t navigate to the corresponding
worksheet.
#VALUE!11 Dec 2005 19:39 GMT4
Hello from Steved
Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510.
=(D3+12)*100
Thankyou
Macro required11 Dec 2005 19:36 GMT3
I would sure like to have a macro that will do the following:
1. Select B1
2. Run down the B col until it finds a blank
3. Then paste in that blank line (starting a col B )what has been placed in
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



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