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 / June 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
New to Excel with Question26 Jun 2005 05:01 GMT1
I am new to Excel and thought this a good opportunity to learn something
about Excel. The Project I am working on requires figuring out the
Vacation hours earned after being employed X number of years. If
present year minus year of employment is greater than (or less than) X,
formula help26 Jun 2005 01:35 GMT3
I need an IF formula  for cells c5 through h5, If a number is entered as a
negative then an error message should appear in cell b10 that says "Error"
Thank You
Concatenation26 Jun 2005 00:53 GMT3
   Is it possible to concatenate multiple cells that are in consecutive
cols and in the same row without having to input each cell reference:- in
other words is there something similar to =SUM but for text.
=CONCATENATE (A1: W1) does not work but what does?
Setting up pages in a workbook26 Jun 2005 00:15 GMT4
I have just created hundreds of workbook pages with different data. What
I would like to know is how do I set up every page to be in the same
format without having to do each one separately? :eek:
Thanks ahead of time.
Extract Unique Values, Then Extract Again to Remove Suffixes25 Jun 2005 22:38 GMT23
I have a list of builders where I want to extract all the unique values.
Using =IF(COUNTIF($A$1:A1,A1)=1,A!,"") works fine to get the first set of
unique values, but I need to extract it a bit further.  The builder names
may be Ryan 50, Ryan 60 or just Ryan.  I need to combine ...
Transition Navigation Keys in Pivot Tables25 Jun 2005 12:40 GMT1
In Excel 2003, I have set Tools > Options > Transition > Transition
Navigation Keys to "on".  The shortcut keys for highlighting a
contiguous range of data work fine EXCEPT for when I am in the pivot
table wizard.
excel to merge for labels  in windows25 Jun 2005 12:01 GMT3
I have been given a Excel spreadsheet and need to print labels with the
information and i am new to excel. I am trying to get the ionfo to word,but
the information doesn't not transfer over.
the answer dont display just the formula i input help25 Jun 2005 10:26 GMT2
when i type the formula in the cell j5  
=k3-100 it does not display changes when
i try to input  a value in k3
the formula is still displayed at j5 and does not show the answer there.
Excel 2003 on Windows ME??25 Jun 2005 02:10 GMT2
Will Excel 2003 run on Windows ME?
Signature

Sarah

How to solve?25 Jun 2005 00:43 GMT2
I want to calculate col A *0.82 and then want to still set the result to col
A,I want to how to do.thank you.
Problems with programs, help files, excel, on partitioned hard drive25 Jun 2005 00:24 GMT7
Good Morning,
Not sure where to post or where to start with this one.
I have a hard drive with several partitions.  Windows 2000 and IE are
on the C: partition and everything else is in it's own partition.  So
search form in sheet24 Jun 2005 23:10 GMT3
I have long column with names and it very difficult to find them.
I lose a lot of time to use the form from “menu / edit “.
I want to create search form or something ells in order to find text quickly
in column, but I don’t now.
Data validation dropdown list24 Jun 2005 23:05 GMT2
The Data validation dropdown list appears to need the list of validation
data same work sheet. I would like to have my validation data on a
separate sheet.
Can this be done?
V92 modem24 Jun 2005 22:52 GMT1
I would like to upgrade my modem to a V92 speed. I'm not really sure that I
know what I'm doing. Are there any unique problems that I need to know
about?
Dell 4550
mortgage24 Jun 2005 22:41 GMT2
 I am new to excel. I have never used it before in my life. I need help
creating an amortorization schedule. I guess that would consist of setting up
the cells so that one can enter the PV, YEARS, AND INTEREST RATE. and the
results shoudl show the payments seperated as principle ...
 
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.