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
Counting Instances Of Item In A Column05 Jun 2005 01:39 GMT15
I have a table with data along the lines of the below.
A_______B______________C_______D
1_______Success/Fail_____Type_____Time
2_______S______________X_______34
Trying to write a formula that changes which worksheet to used05 Jun 2005 01:35 GMT5
I am trying to write a formula that uses a different worksheet in the current
workbook depending on the value from a lookup result and/or the direct entry
of a worksheet name in one cell.
For instance, if my lookup result is November, I want to pull information
need help deleting space in cell with data05 Jun 2005 00:52 GMT5
I have pasted a 1000 dates in the format mm/yyyy  
However, when pasted in, the dates all have a space at the end of the
last c
harachter.  I want to delete that space so Excel recognizes field as a
creating help info for user defined function04 Jun 2005 23:56 GMT3
I have some custom functions written, and would like to provide a little
note on the function variable input box that explains what the function does
(the same as microsofts functions have tips).  Can anyone help with doing
this?
how to type in excel04 Jun 2005 23:08 GMT1
typing letters or numbers do not show in excel
how to change a cell content in a visual basic function?04 Jun 2005 21:48 GMT3
myfunction() is a function i called from, lets say, cell C3 as:
   = myfunction()
in myfunction() i want to change a cells value:
   ......
no lotus 123 key in excel 2003 tool/option/transition?04 Jun 2005 21:30 GMT3
I installed microsoft office 2003 recently.
No more lotus 123 help at transition settings for me to be selected anymore?
I mean the transition navigation key. Where is it in excel 2003?
I need lotus 123 / command from time to time.
Clear cell when value is 004 Jun 2005 19:52 GMT4
I saw an excel spreadsheet whereby
when a user enters any number in any cell
the numbers remain with no change.
But when a user enters 0 (number zero)
Result of date as Month-2 digit Year04 Jun 2005 16:58 GMT3
I have columns of dates that the users must enter as actual dates.  I can
format to display month and two-digit year...but when creating pivot tables
it reconizes the entire date.  Since I want to summarize only by month and
year or by year only, is there a formula or statement ...
locking or grouping rows04 Jun 2005 16:39 GMT4
I have made an address book and find that I am unable to sort it.
I "think" I need to group several rows.
1st row:  name > street number > children names > Home Phone
2nd row:            > city, state, zip > more names       > Cell Phone
Deleting All Range Names04 Jun 2005 14:03 GMT3
Is there an easy way to delete a group of range names or all the range names
in a sheet at one time?  The only way that I am aware of is to delete each
range name separately.
Training Source for creating Excel Pivot Tables04 Jun 2005 13:27 GMT1
I am wanting to find some good training sources for creating excel pivot
tables.  I currently use pivot tables...but need to go beyond the basics I
have learned by trial and error.  Thanks.
Merging 3 Workbooks without using macros04 Jun 2005 11:56 GMT1
There are three of us that keep track of data for our respective departments
in Excel but would like to merge only certain data into one master worksheet
so our boss can see a general snap shot as to what we are doing.  Is it
possible to merge our workbooks automatically as we ...
dates in excel04 Jun 2005 10:02 GMT1
I have a need to automatically save the current date to a cell in an excel spreadsheet every time the sheet is saved.
Today() always returns the current date, so once I open the sheet on a new day I can no longer see the date the information was last updated, i.e. saved.
Any help ...
lost password04 Jun 2005 09:53 GMT2
I have forgotten a  password of the worksheet I protected. Now after long
time when I tried to unprotect it I just could not unprotect it. Could
someone help me please overcome this problem. Please.
Thank you
 
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.