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 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Formula help req'd18 Jun 2004 14:28 GMT2
I am having trouble trying to display result.
Basically say A1 has 10 in it and A2 has 5 in it A3 has the formula
A3 =sum(A1-A2) {answer =5}
What I want it do do is... say A4 displays HW as per the key.
Sharing and Unsharing18 Jun 2004 13:39 GMT1
I am creating a spreadsheet to be used by multiple users on a network
and  set a workbook to be shared, then noticed I needed to make some
changes. I tried to unshare this file and found I could not doe this.
Is there a way or a different process for saving a file to be shared
Summarizing Expense Sheets18 Jun 2004 13:27 GMT3
I have an excel worksheet to keep track of 5 different types of expense
that occur each month.  They are listed by the date they occur and I a
given a total for all expenses.  However, I need to know over the mont
how much was spent for each type of expense.
Search a string in all worksheets ?18 Jun 2004 12:11 GMT2
I am searching for a string say ABC in all worksheets in
Excel 97.  However, it seems that it only allows me to
search it in the current worksheet.
Is there any suggestion ?
Help with a formula18 Jun 2004 11:40 GMT2
I am doing an assessment for TAFE and need some help doing a formula, so if
there is anybody out there willing to help, I would really appreciate it.
Using lookups, vlookups of If's - we need to work out the tax payable on the
gross wage.  Currently my gross wages are in Column H ...
Searching for text18 Jun 2004 08:59 GMT2
Max helped first maybe again? :)
I have a search that I want it to look for two separate values in the
same search string.
the search is embedded in an if statement like so...
Why does Excel Print  Perfect Circles - 'Oval'!!18 Jun 2004 08:40 GMT5
Perhaps someone has already found the answer to this problem but
cannot find it and neither can the experts in a Computer Magazine.
Excel 97 ~ 2000 insists on printing a perfect circle as an oval, cop
the circle to Word and it prints as a circle. I have tried this o
Does anyone know how to create a formula to sum up time sheet hours?18 Jun 2004 06:06 GMT2
I have a worksheet that has employees punch in times, punch out times
and lunch out/in times. I am trying to create a formula that calculate
the total amount of time worked.
First I want to take time in subtract it by time out, then take th
Writing Code18 Jun 2004 02:18 GMT1
I am a novice at writing code so I need help.  I am trying to create an input box to pop up in an excel form and have the information that was put in the box to drop into a particular cell?
Help!
question about matrix formule18 Jun 2004 01:35 GMT3
let consider this (in cell A1 through B3):
bob    10
bill        8
bob      5
Table of Contents for Files18 Jun 2004 01:23 GMT2
Does anyone know of a way to populate a column with the names of files
that exist in a folder?  I would like to use this to create a table of
contents for folders.
---
Another suggestion, please18 Jun 2004 01:19 GMT8
I have a spreadsheet of addresses. Following previous assistance in this
group, the sheet is sorted perfectly......nearly.
The addresses are numerically sorted - 1 Anystreet, 2 Anystreet, 3 Anystreet
etc. The house numbers are in separate cells from the road name.
Run time error 9118 Jun 2004 01:17 GMT2
I am such a novice at this....I have the following code that partiall
works...(guess that means it doesn't work!)  
I can cycle through the first do while loop and then the code crashe
with a run time error 91 -- Object variable or With Block variable no
help to adjust this formula18 Jun 2004 01:00 GMT4
=VLOOKUP(A1,$J$1:$K$3,FALSE)
I would like my search to not have a end
is there a way to keep it open.
when i add new patients to this list do i have to keep changing th
Can't paste text into a Merged Cell18 Jun 2004 00:56 GMT1
I've just upgraded to Office 2003 and now I can't paste text selected from
Word into a merged cell in Excel - is this normal or am I doing something
wrong?
Thanks
 
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.