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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
pmt function12 Jul 2007 08:07 GMT1
Scenario:
I have $x currently and want to save up to $y.  What is the formula to tell
me how much I need to save each week for say 1 year to go from x to y given
a standard, fixed variable rate?
Spss verse excel12 Jul 2007 07:48 GMT5
I want to do some statistical analysis and probability calculations. my
professor advised me to use spss, which I am totally unfamiliar with. Does
this software offers functions that excel can not perform I prefer to do all
my analysis with Excel which I am used to it.
JIS / ASC Functions in Excel 200712 Jul 2007 06:31 GMT3
I have several text strings in single-byte Japanese I need to convert to
double-byte Japanese. The JIS and ASC functions in Excel are listed in Excel
Help, but they are not available in Excel 2007.  Attempted use generates a
NAME? error.  I am running English Vista, and I have ...
Is there a way?12 Jul 2007 04:13 GMT4
Is there a way to add up the number of lines that have writing in them versus
an amount?
For instance I have this spreadsheet and I want to add up how many sconces I
have and every time I add a new one the number updates.
Please Help...12 Jul 2007 03:10 GMT5
I had a table of data and would like to go the following... please help...
       A       B       C       D
1   Andy    78     98      85
2   Jane     45    65      96
vlookup12 Jul 2007 02:57 GMT1
can you have the result return a color for a certain value? thanks!
Calculate value in a text filled cell12 Jul 2007 02:05 GMT6
How can you setup a cell with text and assign a value to that cell so when
you sum the columns, the value computes.  For example, I have a cell contract
terms with a text value of "6 months", how do I setup the cell so it's value
for formulas is "6" so it will compute the sum of ...
PROPER FUNCTION12 Jul 2007 01:38 GMT5
HOW DO I USE THE PROPER FUNCTION FOR MULTIPLE NAMES THAT NEED TO BE CHANGED?
How do I insert cells in a macro?12 Jul 2007 00:32 GMT7
I have a worksheet with 6 columns 300+  rows.  I have a macro that preforms a
a filter, delete rows based on blanks, turn off filter and save as values.  
Now I need to find "GRAND TOTAL:".  in Column A. This is variable.  Once
found, insert 7 cells and shift right.
Thank You!12 Jul 2007 00:20 GMT2
Just wanted to take a moment to thank many of the regulars to this group for
all of their wonderful help. I'm a realtive "newbie" to Excel, and I have
received such great help from people like Max, Roger, Toppers, BJ, Pete UK,
Driller, and Rick. You all are so gracious in sharing ...
Extract Middle Initial from Name11 Jul 2007 23:17 GMT10
I have a list of names; some of which contain the fistname, middle initial,
and last name. The other names in the list are only first and last names. For
example: John T. Doe and John Doe. I need to extract the middle intial and
the period after the MI so that I end up with a ...
Multiple Criteria11 Jul 2007 23:08 GMT4
This is on Sheet1 (database of prices):
     A             B             C                D              E          
      F
5                                                  Type I     Type II        
NZ function equivalent in Excel11 Jul 2007 23:04 GMT6
Does Excel have an equivalent to the Access function NZ?  I want to avoid
having to perform a double VLOOKUP (one to determine if the value is
non-numeric/non-existant, the second to pull the actual value in the event it
is numeric).  
delete macros11 Jul 2007 23:01 GMT1
An Auto_Close macro was set up by someone else and we don't want it in the
file anylonger, weare getting some strange messages when closing out of the
file. I followed the instructions for deleting but the delete button won't
highlight, it stays gray. I don't know if it was ...
How do I insert cells in a macro?11 Jul 2007 22:32 GMT7
I missed the answer by 15 minutes, then went on vacation for a week.  The
answer didn't work, however, and this problem truely has me bugged.  My
question is now past page 15, so I thought I would try again.
I have a worksheet with 6 columns and 300+ rows.  In column "A" I need to ...
 
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.