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 / May 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how do I make an excel comment box bigger?18 May 2006 17:39 GMT5
I am looking at an excel worksheet that was sent to me. There are several
comments on the sheet. One of the cells is too small and I cannot read
everything that is in the comment box. How can I make this box bigger so that
I can see the entire contents
Can you perform Math functions with ActiveX Checkbox controls?18 May 2006 17:23 GMT1
Is it possible to use a series of ActiveX controls (Checkboxes) and then do a
math function, such as COUNTIF to count the number of check boxes that are
checked (true)?  What should be used to determine the state of the checkbox
and what would the proper syntax be?
divide by zero18 May 2006 17:01 GMT3
i have 2 cells: f4 and f8 on status spreadsheet. they may not be populated,
(have a value in the cell), all the time. need a formula that will calculate
when only both of them are populated. and not return a #div/0!, divide by
zero error. when neither or only one of those cells ...
Comparing against first non-blank cell18 May 2006 16:59 GMT1
Okay, here's the problem:
I have two columns:  A and B.  A is a listing of stock prices, in
random order.  B is a column of Peaks or Price Highs, based on column
A.
Sort function on Pivot Table18 May 2006 16:58 GMT2
Does anyone knows why Pivot table do not sort properly if your sort is based
on 2.3.or 4... column. I have tried many times and always resort to 1st
Column. I have also tried the Advance function of Pivot Field.
Thank
copying macros18 May 2006 16:51 GMT2
A colleague of mine wants to create several macros that the whole team can
use.  He intends to put these macros onto a drive that we can all gain access
to so we can open the workbooks.
Once the workbooks are on the shared drive, how do we copy them into the
Excel Woes - Formula bug (I guess)18 May 2006 16:44 GMT3
Problem: an excel file is being used for quite some time now (about 2
years), and it suddenly stops updating cells with formulas...for
example: =SUM(c1:C10); the cell is not updated when a value is added to
say... c5. Does anyone know what is happening?, I hoping that I can get
US states18 May 2006 16:44 GMT1
Does anyone know how to convert US states on excel?  e.g., TX = Texas.
Sumproduct-multiple criteria for same range "OR"18 May 2006 16:43 GMT3
I found a solution to my problem....
However, to designate "or" between multiple conditions existing in a
*single* range, you can create an array of these "or" conditions, using an
array constant, as:
Newbie post - help with Subtotal please!18 May 2006 16:38 GMT9
This is my first post so I hope it is in the right forum.
I have a spreadsheet with subtotals on and we have a problem inserting
new rows.  I thought that when a row was inserted above the subtotal
row, the subtotal would update automatically - but it doesn't.
excel "Networkday" function18 May 2006 15:55 GMT2
How do I assign current calendar date to end_date in order to calculate # of
days worked from hire date to current date?
Function to Convert dollar to text?18 May 2006 15:00 GMT2
I am looking for a function to convert a dollar amount (number) to text.  For
example, $10.50 would display as "Ten Dollars".
PivotTable18 May 2006 14:53 GMT1
I am usually really good at figuring things out, but this has me totally
stumped.  I have a spreadsheet which contains the following headings:
C-section Indication    Main Method of Delivery   Aux Method of Delivery
Physician 1
Automatic League Sort18 May 2006 14:37 GMT4
I have a league table (attachment table named 'World Cup League').  I
updates scores as i enter them into a data table that precedes i
(titled 'Games Won').  I would like to be able to automatically sor
the 'World Cup League' in descending order every time i enter data int
IF statement colored results18 May 2006 14:29 GMT1
In an IF statement is possible for true and false results to be different
colors?
 
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.