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 / General Excel Questions / May 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Comparing Columns to each other25 May 2007 20:17 GMT2
I had a question about comparing columns....is it possible to compare
columns to each other.  So, for example...
Column1     Column2
Apple          Orange
Importing problems25 May 2007 20:16 GMT3
I am attempting to recreate my address book as an excel file I have the
precious version in an address book program it's an address book file. Any
suggestions?
formula question25 May 2007 20:02 GMT3
I am working on a spread sheet where I am calculating the percentage of
retail markdowns.  I am using the formula below:
=SUM((H3-J3)/H3)
But, in some cases j will be empty, so I want it to use i instead.  Is there
loading25 May 2007 19:59 GMT2
in office 2007 since I installed it If I load a file by double clicking on it
from within my My Documents folder Excel starts and loads an empty page.  If
I start Excel and then go to File/Open the Excel file loads perfectly. Does
anyone have an idea as to what is happening?
Time Stamp25 May 2007 19:51 GMT2
We are entering data in a call.  We want to capture the time that the data
was entered.  We have tired the now() function and the today() function, but
these change on recalculation.  Can anyone think of a way to capture the time?
How do I prevent excel from opening with a blank worksheet?25 May 2007 19:50 GMT9
I rarely start a new spreadsheet from scratch...most of the time I want to
just open Excel, but with no blank/template loading automatically.  Where do
I set this switch...maybe in the Registry??!  thanks in advance
Help Solving a problem25 May 2007 19:32 GMT1
I have a total number of cubic meters (CBM), and need to figure out the best
combination of shipping containers that leaves the least amount left over.  
Here is an example:
Total CBM = 311
column names25 May 2007 19:13 GMT2
the column names in my spreadsheet are numbers (instead of letters).
how do i switch it back?
Return the values for the same names across a row of data25 May 2007 19:04 GMT7
Microsoft 2003 - I have a row of data that contains user names.  Below this
row is an "x" in each cell that meets a certain critieria that I already
filled out.  Now I want to combine all the names in the first row so there is
only one name, not multiples of the same name, and ...
Macro using autofilter25 May 2007 18:54 GMT5
I am building a macro so that people in my organization can produce reports
based on a customer satisfaction spreadsheet database.  I need to be able to
pull data from the customer responses based on date ranges and I am thinking
that the autofilter is the best choice for this.  ...
Mail merge25 May 2007 18:53 GMT1
When I do a mail merge with postcard templates every third data line is
removed.  Why is this?
How do I enable copy in a protected workbook?25 May 2007 18:39 GMT1
I have a password protected sheet in Excel 2003 with locked cells. Copy and
paste is disabled but I'd like for this to remain available. How do I get
both protected cells and the copy paste function to work?
Conditional formatting: format when range of cells are blank25 May 2007 18:24 GMT1
When using the conditional formatting is there a way to determine if a range
of cells are empty?  Is there a way to determine if a named range is empty?  
As well, is there a way to use AND/OR when using conditional formatting?
Chad
Pivot Table #DIV/0! Error25 May 2007 18:21 GMT3
I created a Pivot table and set all fields to be numeric.  After that I went
to the Field Settings and selected AVERAGE and recieve the error #DIV/0!.  Is
there anyway to get around this printing?
How do you stop excel removing the leading zeros in a cell?25 May 2007 18:16 GMT2
I need the leading zero to be actually in the cell so formatting the cell
using custom or special will not work as these seem to be for display only.
The cell cannot be formatted for text or you cannot put an apostrophe before
the number as the spreadsheet is read into a database ...
 
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.