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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
array formulas17 Mar 2006 17:41 GMT2
I'm a liitle confused about the difference between "regular" formulas and
array formulas.  For example, I'm using "SUMPRODUCT" with 2 criteria to sum
values.  
I am getting the correct sum, even though I don't have the array brackets in
Is this possible?17 Mar 2006 17:38 GMT11
I have created a database of names & addresses from a software progra
called "CLIP" into excel, which in turn will become a label mail merg
in MS word consisting of 900-1000 customers (for a mass mailing).
The problem is, the names were created last, first and I would like t
How do I specify subscript within functions in Excel?17 Mar 2006 17:37 GMT1
I would like to display numbers as subscript within a combination text-number
string (but solely the numbers).  This is generally important for aesthetic
appeal and legibility.
Example: I'd like to automatically generate the formulas for hydrocarbons
Q about exporting macros17 Mar 2006 17:25 GMT2
I have forgotten the best way to export a macro from one computer, then
import it to another.  
Depending on where I am, either under tools > macro > macros > edit,
or under tools > visual basic editor, I see two different files types, .cls
How do I transfer formulas but not the information?17 Mar 2006 17:05 GMT1
I have a spreadsheet that consists of 8 worksheets, each page is formulated
to transfer accumulated data to another sheet.  It is for statistics for a
club.  My questions is how do I transfer the worksheets and the formulas
without transfering the data?  I have tried to save as a ...
What makes diferrent? with or without '+'17 Mar 2006 16:55 GMT2
Hi,
Pls let me know what are the diferrent with or without the simbol '+' in
this formula:
=+'sheet1!'A1
formula help to change row colour automatically by some conditions17 Mar 2006 16:51 GMT6
Hi Good People,
I am working in excel worksheet for a payment collection activity and in
culumn Ato Column Z i have detail of customer and in column AB i have amount
of payment received and in column AA i made a condition by using if formula
Can I import many .txt files in a single worksheet automatically?17 Mar 2006 16:43 GMT1
I have 1000 text files that I want to import in a single Excel worksheet. I
know I can do it manually (open each file individually, select the coma in
the text import wizard and click finish, then copy and paste in the single
worksheet), but is there a way to do it automatically ...
Find avg & Max for grades17 Mar 2006 16:31 GMT7
I have range (A2:A35) for subject grades (A,B,C,D,E)
What I want to know, it is possible to find avg grade and max grade score by
student?
pls guide me.
how to reset form17 Mar 2006 15:54 GMT1
How do you reset a form after macros have run?  I have a macro that deletes
all lines that have a 0 in column C after data has been pulled in from other
sheets. I need to add a button that will restore the form to it's original
state.
how to convert amount in figuers t oamount in words17 Mar 2006 15:39 GMT1
if i want to convert amount in figueres 100 to amount in words as hundress
how can i do is there any function or way to do it
If Function17 Mar 2006 15:20 GMT1
What I want to do is get excel to compare a reference number to a lis
of of reference numbers and if it is in the list more than once out pu
-1.
I have been working on this for ages but cannot seem to find a way o
Average of Last 1017 Mar 2006 15:17 GMT16
What I am trying to do is track a 10 week rolling average, where scores
are entered weekly in row A6 thru W6.  The formula needs to count back
starting with W6
until it counts 10 scores then average them.  Some cells may be blank.
Convert from number to text17 Mar 2006 14:49 GMT2
sir in excel how we convert number to text in english version???
Combining data from 2 worksheets17 Mar 2006 14:21 GMT1
I have 2 worksheets with the following data:
Worksheet 1---All Project (A1-A21)---Number of sites (B1-B21)
Worksheet 2---Customer Name (A1-A39)
then columns B-H have the All Project value if applicable.
 
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.