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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Problem with CSV file21 Nov 2007 15:37 GMT6
A customer has sent me a csv file which contains two sheets when opened in
Excel 2000. This was done because the first sheet contained the maximum
number of records Excel can handle. I need to import these lists into
Paradox (a database), so I need to separate the two sheets into ...
Creating a report with .jpg files in it21 Nov 2007 14:54 GMT1
I need to create a report to document equipment performance that will include
the usual columns with text information.  I wish to include .jpg screen caps
in the report.  I would like to use a hyperlink but I want to make sure that
the spreadsheet and the .jpg files cannot be ...
SOVER ADD IN21 Nov 2007 14:52 GMT1
I PURCHASED STUDENT AND TEACHER EDITION A YEAR AGO.
7041-056-3526131-56025.  MISPLACED DISK.  REQUIRES FILE
E4561412.CAB TO COMPLETE INSTALLATION OF SOLVER.  HOW CAN I GET
THE FILE WITHOUT MY DISK?  
Fixed  & Reducing Balance Loan Calculation.21 Nov 2007 14:35 GMT3
Could anyone, please guide me following two questions.
Loan Calculation For
Fixed Annual Interest Rate
Reducing Balance Annual Interest Rate
using time format in a formula21 Nov 2007 14:35 GMT3
I'm trying to use a formula that if c3 is >:45 seconds then etc....vlookup
the score that relates to that specific time
counting data across worksheets21 Nov 2007 14:19 GMT5
I need to do the following:-
I have 12 worksheets (one for each month) which contain information on staff
members, when they were on duty, when they were on holiday etc.
I have successfully used COUNTIF to work out how many days holiday each
Copying year21 Nov 2007 13:49 GMT2
1.How can  copy the months with same year i.e. Mar 2003, Apr 2003, May 2003
etc because as I drag the cell containing Mar 2003 down, the year gets
incremented
2. Last week I have created marina.xls file which was working fine. But
Opening Excel 2003 File21 Nov 2007 13:48 GMT1
I have a file saved correct. For example the file name is water.xls.
When I open the file water.xls it opens and I can edit it. However, the file
name has changed to water1 (without .xls). I can reopen water.xls, while
water1 is open and the new name is water2 (without .xls). This ...
DBF File21 Nov 2007 13:38 GMT2
How  can I save as dbf 4 file in Office 2007?
counting blanks in a non-consecutive range21 Nov 2007 13:38 GMT3
I need to be able to count the number of blank cells in a range, but my range
is made up of non-consecutive cells, ie B2, D2, F2, H2.
I have tried naming the range 'actual' and then using =COUNTBLANK(actual)
but I get #VALUE!
Repetive Formatting/Creating a Toolbar button21 Nov 2007 13:38 GMT11
I work on different worksheets all of the time and have to choose format (on
different cells specific font withing the cell). I normally right click on
the font within the cell I need to format and choose format, select  Font,
change the color to red, and choose strike through. ...
Password21 Nov 2007 12:36 GMT2
Incase if I forgot the password of my excel sheet? Is there any option to
open that sheet?
file replace21 Nov 2007 12:10 GMT2
I have 3 users working on a series of linked Excel files all feeding to a
final output file (STRATEGY OUTCOME 2007 WIP.xls).  The files are not shared.
Last night one of the user A had the final output file open (STRATEGY
OUTCOME 2007 WIP.xls) - she had full access.  User B saved ...
vlookup looking at many worksheets21 Nov 2007 11:36 GMT2
I have a problem with one of my spreadsheets.
I have worksheets for 12 months of the year(Jan-Dec) and a summary sheet.
The format for each sheet and summary sheet has names down one side and code
names going across as shown.
count 2 column21 Nov 2007 10:21 GMT2
I would like to count following criteria. Do there any formula can help IN
Excel ?
Closed    LCD
Closed    LCD
 
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.