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 / New Users / May 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel IF formula08 May 2005 18:15 GMT7
To whom it may concern
What it is the formula required in Microsoft excel that
will return a value of true in cell K1 if the values in
cells G1, H1 and I1 are all BLANK?
Eliminating a Column from Formula08 May 2005 17:44 GMT6
Is there a way to eliminate a specific column or columns from any
formula ie: sum, average, count etc. when the formula includes all
columns
In other words if the formula is =sum(A1:H1) I would like to eliminate
Purchase Order/Invoice ledger08 May 2005 16:48 GMT1
What I would like to do is to keep track of  everything that we purchase over
12 months. I have already partly designed the worksheet with 5 fields, the
last two being Purchase Order cost and Invoice cost. I have totalled both
columns.
Time card 24 hour Please help if you can08 May 2005 15:28 GMT1
I have modified the time card template that comes we Excel 2002 its
the standard template in the spreadsheet solutions under time card. I
have it exactly the way I want it to work but all of the fields that
you put times in will not let me go over 24 because its looking for a
problem with the command - method "UpdateFromFile"08 May 2005 14:45 GMT1
Dear Friends!
I already asked for help with the method "UpdateFromFile". The aswer from a
member of our group was: "help is OK". I am sorry, but I need a piece of
code, containing the command. I am not shure what must precede the
average function in Excel 200208 May 2005 13:50 GMT13
I wish to obtain the average of a number of numeric cells but wish this
average to be ongoing rather than restricted to a range of cells.
For example  
=AVERAGE(D13:D17) will only give the average of the cells D13 to D17 but I
about Password08 May 2005 10:44 GMT3
Hello~~ ^^
I wrote out a document and stored it.
And I locked the document with personal code
number(password).
HOW CAN I SHOW OUTPUT IN FEET INCH FORMAT08 May 2005 06:01 GMT2
I’m trying to make a calc sheet that shows my measurements in feet and inc
format ( 5' 3-1/2")  or something similar.
thank you for your hlep
limking workbooks08 May 2005 05:50 GMT1
I have 4 workbooks in seperate folders that I need to combine into one
monthly summary.  The workbooks are different but each contain a columns
named, B/L,Amount,Billed.  These are the 3 columns I want merged into one
spreadsheet.  What would be the best way to do this?
MICROSOFT EXCELL (XLS)08 May 2005 04:04 GMT1
i need this to access pictures of female friend overseas, please help. its a
spreadsheet file, XLS. THANKS!
xls to dBaseIII issue08 May 2005 00:40 GMT1
I have to convert an excel file to dBaseIII for a mail list program.  When I
choose save as dBaseIII it saves ok but I have two problems.
main problem is I have one column with a 2 character width with numbers.  I
have to be able to format the numbers as....12 , 34, 06, 09...etc.  ...
Superformula required for looking up Duplicates in a range07 May 2005 22:05 GMT11
I've been trying to construct a Duplicate entries/Lookup superformula
all to no avail.
Column A is a helper range (optional). Column D contains strings of
numbers and/or characters.
Average Row Formula07 May 2005 19:16 GMT5
Is there a way to calculate the average of a row if some cells are
empty but when calculating the average they should have the value of
the cell to the left?
If the following data is enterered
Excel: Latest Version?07 May 2005 19:11 GMT6
I'd like to surf Australia's Ebay for the latest Version,
I aim to export data from a large Visual FoxPro Database.
What do I look for, and do I need any add-ins etc.
Thank you for any advice.
External query where parameter is a sheet cell07 May 2005 17:53 GMT1
I want to run an SQL to an external database source where the parameter of
the query is specified in a sheet cell.  For example:
   select amount
   from mynumbers
 
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.