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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how to fourth root a number on excel18 Oct 2006 19:29 GMT7
does anyone know if you can fourth root numbers on an excel spreadsheet?
Adding time data18 Oct 2006 19:14 GMT2
I have a worksheet in which various times are expressed in the cell format:
h:mm
I need to add columns of data in this format and express the total in hours.
I am finding, though, that once the total exceeds 24 hours, the format
Find cell reference in an column of numbers?18 Oct 2006 19:13 GMT3
I have an column of numbers, e.g.
a1 - 0.03
a2 - 0.17
a3 - 0.35
Inserting data between cells18 Oct 2006 19:07 GMT1
How to insert data & automatically push remainder forward. Ex. put jacob
between jerry & sue?
john     james    jerry
sue     sharron     sam
Excel:  Having more than 3 conditional formats would be helpful.18 Oct 2006 19:00 GMT2
In Excel, I have a series of formulas that outputs one of six results....
let's say 1, 2, 3, 4, 5, and 6 (for simplicity).  I would like to assign a
color to each of the results of the formulas.  So 1 would be blue, 2 would be
green, etc.  Excel limits me to 3 conditional formats ...
what formula to get total from two different columns18 Oct 2006 18:58 GMT2
I have a worksheet that i want to use to keep track of my bank account i.e
money in and money out to give me a total in the third column and cannot work
the formula out as 1 column is taking away and the secon column is adding?????
Frequency Function question18 Oct 2006 18:58 GMT3
I'm attempting to use the frequency function but seem to be getting the wrong
solutions.
Th formula is thus: in c2:c5  =Frequency(a2:a17,b2:b5)
It looks to me like the formula is fouling.
Lists referencing lists...is it possible?18 Oct 2006 18:37 GMT2
I am looking to create two different lists for users to chose from.  However,
I would like the second list to be dependent upon the item selected in the
first list.  Is this possible?
IF OR functions18 Oct 2006 17:53 GMT6
IF J4=D14,1 or if J4>E14,0 or if J4>D14<E14,0.5 how do I make this work?
How can I set the column that excel returns to when I hit Enter?18 Oct 2006 17:18 GMT2
When I am done entering info on one line and hit Enter/Return sometimes it
goes  to the next row in column A and sometimes it goes to another cell in
the next row.  There doesn't seem to be any rhyme or reason to it. Is there a
way to set it return where you want?
excel: monthly download of 1000 members, need to update quickly18 Oct 2006 17:16 GMT2
excel 2003.  we obtain national download monthly for our 1000 member group.
Need a way to cross check and update information quickly.  13 columns per
member to check.
How to find the most recent date in a column based on other column18 Oct 2006 17:01 GMT7
I am working on creating a worksheet which will help me keep track of the
players stats in a game I am running.  The Spreadsheet currently Tracks the
following fields.
Date Posted, Poster, Contract/Objective, and Words
Can an Excel workbook number sheet pages sequentially?18 Oct 2006 16:47 GMT5
Help please! I trying to get an Excel workbook to number it's sheets
sequentially - can this be done??
Why are some imported cells changing to zero?18 Oct 2006 16:47 GMT1
I am trying to import info on some cells to another worksheet. I type = in
the destination sheet and click the cell I want from the original sheet but
the number is coming up as 0 in the destination cell. Some of the cells I do
this with are fine and others will give me 0.
Can you cell reference for the title of the worksheet tab?18 Oct 2006 16:37 GMT1
I want to pull the workshet name automatically from a cell within the
worksheet so that it is dynamic.
 
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.