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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
PLEASE HELP--going crazy with a simple calculation14 Nov 2005 18:42 GMT3
I have 'asked' Excel to divide two cells (each cell has been set to "number;
2 digits")
The numerator is a cell that refers to another cell, where the value of the
original cell entered states 15000 (number, 2 digits); the denominator refers
Excel subtotals cells with a formula - HELP14 Nov 2005 18:31 GMT4
I am subtotaling (using count) a few columns.  When the column truly has
nothing in the cell the subtotal does not count it.  However, if the cell has
a formula "=countif(xxxxxxx)" then it counts it in the subtotal - Why?  I am
so confused and under pressure.
Merging worksheets14 Nov 2005 18:13 GMT1
I have several spreadsheets which I need to enter into one central
spreadsheet. The column headings are identical on all the sheets. The content
is text.
EXCEL OPENS THE SAME FILE TWICE, HELP!14 Nov 2005 18:12 GMT1
when i open an excel file it opens it up twice.
why is this happening.
Q - Excel 2000: How to refer to worksheet in the same book?14 Nov 2005 17:54 GMT10
 I have twelve sheets in the book called "Jan", "Feb"  to "Dec". Now I will
use value in the two sheets by this format:
 Row1 will contain columns, "jan", "feb", and etc.
 Row2 should be like "=JAN!b2", "=FEB!b2", etc till "=Dec!b2".
How do I JUMP from pane 1 to Pane 2?14 Nov 2005 17:51 GMT5
I split a worksheet into 2 panes.
Pane 1
Pane 2
What keyboard keystrokes can I use to JUMP from
why does the toolbar have a button, $ and is said currency,it giv.14 Nov 2005 17:38 GMT1
Whay does the toolbar have a button with a $ sign and indicates it will give
you currency, in fact it gives you the accounting format
spell out amount?14 Nov 2005 16:57 GMT4
I'm working on a spreadsheet on which I have to spell out an amount. You
know, like they do on checks; One Thousand Three Hundred 00/100...
Is there a way to do this in Excel?  Maybe an add-in or a third party
software?
Creating Formulas In Excel To Calculate Time Intervals14 Nov 2005 16:52 GMT1
Each month I receive a report that has entries for time intervals in the
following format days:hours:minutes (e.g. 02:13:07 - 2 days 13 hours 7
minutes).  In order to perform calculations for a group of that data I
decided its best to convert everything to base 10 (minutes).  To ...
Write cell info to external file14 Nov 2005 16:33 GMT7
Is it possible to make an external file from the contents of a cell? For
example if I have "Text acbd" as the contents of cell A1, can I write it to a
new file called Text1.txt?
If so, can the file name Text1.txt be in another cell, B1 for example?
Can I make rows of an excell spreadsheet 'selectable' (on/off)?14 Nov 2005 16:21 GMT3
I have a spreadsheet of 20 rows (and 20 coulmns). The bottom row of each
column is a total. I would like the user to be able to select the rows (using
like checkboxes or something?) to include in the column total row. Is this
possible?
Unable to sort data in excel with cells containing if & hlookup14 Nov 2005 16:06 GMT1
I am trying to sort a column of data in excel. The cells to be sorted have
formulas with multiple “if” and  “hlookups” statements.
I went through the sort wizard but I do not find the data sorted. Do you
know of any limitations of sorting with formulas contained in the cells?
how do I sort email address by ISP?14 Nov 2005 15:20 GMT3
I a trying to sort a customer list with email addresses by ISP to group like
ISPs together in Excel 2003
Multiple if or multiple vlookup14 Nov 2005 13:48 GMT4
I have 3 data sources and one summary page. I want to lookup a cell i
my summary page and find the result in either one of my 3 dat
sources(All within the same spreadsheet)
In summary I need
Linked Combo Boxes14 Nov 2005 13:35 GMT3
Is it possible to link two combo boxes so that your selection in the first
box limits the amount of information you have available in the second box?
 
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.