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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
convert column values15 Jun 2006 19:13 GMT5
I'm sorry if this is already here somewhere, but I could't find any references.
I need to upload a list of people into our computer system and this list is
comprised of their names and the code for the branch where they work. The
computer system into which I need to upload this ...
how do I lock values in excel15 Jun 2006 18:55 GMT1
I am working on a spreadsheet where the values on one sheet in a workbook
are appear on a second sheet in the same workbook using the following formula:
=('Employee List'!A171)
The input sheet is called Employee List.  I would like to "lock" the values
Help...  in excel.15 Jun 2006 18:54 GMT1
I'm working from a download excel file that I copy and paste to an existing
work book.  I have a sumif formula that i'm using to pull information from
the download but am running into a problem with the  "cr" (for credit) in my
download.  I need for it to show  "-" or "( )" .  Is ...
Formula for computing day of the week and time15 Jun 2006 18:45 GMT4
I have a cell containing information in the following format:
Mon 6/12/2006 2:56 PM
I would like to break this into 3 individual cells for day (spelled out
IE Monday) date and time.
Simple SUMIF, I think...15 Jun 2006 18:33 GMT7
I have 2 columns of data.  In col B I have a % value; in col C I have various
project names.  I need a formula that will show me the total of col B for
each project name in col C.  There is no data after col C so I could use
those cols for the results.
calculating adjacent columns in a work schedule15 Jun 2006 18:30 GMT3
I am working on a schedule where there are many different workers, and many
different shifts of different lengths are being used.  I have been trying to
create a formula that sums the total hours for each person, based on the name
in the adjacent column.  For example:
Excel worksheet functions question.15 Jun 2006 18:23 GMT3
Basically I am new to excel but I am trying to have it where when someone
inputs a certain number from a list of numbers that it will put in the proper
"x's" in the column on the sheet. I have put the list of numbers and the X's
that belong to those numbers in columns on sheet 2 ...
HELP WITH A FORMULA15 Jun 2006 18:23 GMT4
I need help figuring out a Formula, in my Excel Sheet i have Total COST in
Cell E65534 and in F65534 I have Cost that I charged My Customer.  I need a
Formula that will calculate the Margin that I had earned for that
transaction.  So that i can figure out what my margins are, ...
averaging times15 Jun 2006 18:23 GMT4
I have a problem with averaging times.
This is what I have
e12 – i12 are input as the time taken to achieve a task.  This could be
anything from 0.01 (min.secs) up to 9.59.  These times are then averaged to
locked cells with 2 different passwords?15 Jun 2006 18:22 GMT2
Trying to setup a timesheet where the user can paste a jpg of their signature
and then password protect it. THen forward it to the supervisor who would do
the same. Anyone know of a way to do this?
Thanks!
Creating a formula using RAND15 Jun 2006 17:53 GMT2
I have a spreadsheet that has a group of peoples names on it. I want to
be able to create a formula that will cause it to randomly choose one
of those people on the list. I know there is a way to create a formula
for this but I completely clueless on how I would type the formula in.
Need help with averaging a time but dates are messing up the result I am trying for.15 Jun 2006 17:48 GMT4
I am attempting to get a worksheet that averages times but I am running
into a few problems.  For example I have this setup....
A1 = 05/11/06 11:00 PM
B1 = 05/13/06 11:30 PM
indirect function within sumif to reference other sheets15 Jun 2006 17:46 GMT3
I have a workbook with many sheets, most of them being financial
information, ie last year actual / budget, this year actual/budget etc.
I then have a sheet which I am making a report on to summarise all of
the other information. Each line is a sumif of all the relevant cost  /
Assistance with Formula15 Jun 2006 17:11 GMT3
I have a workbook which I produce my Sales Quotes in.
Basically, on one page, I feed in all the relevant information and then
through various formulas (eg. =B29) where it looks to see what's in the cell
where I've fed in the info, it produces the quote on a standard template,
How do I set up a formula to throw out the 2 lowest scores?15 Jun 2006 17:08 GMT1
I would like to enter 8 quiz grades throw out the two lowest scores and get
the average of the 6 remaining scores.
I know there's got to be a way to do this, I just haven't figured it out
yet. Any help would be appreciated
 
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.