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
Time (Hours) calculation16 Jun 2006 07:28 GMT1
I want to be able to place a time & date in one cell,
Place a total hour figure in another cell,
and a result in (Time & Date) placed into a 3rd cell.
How would i do this if say:
Starting another program out of Excel VB??16 Jun 2006 03:52 GMT1
How do/can I start another program, like WORD or NOTEPAD, from an EXCEL VB
routine?
I tried doing it with the Marco definition button, but that doesn't collect
things that happen outside EXCEL.
Average of lowest 5 of 20 values?16 Jun 2006 03:49 GMT5
The following are what golf handicappers call differential values. I've
listed 25 of them. To compute my golf score handicap I need to take the
average of the lowest 5 of the last 20 of these values, and multiply that by
0.96.
look up a value in one column to another colum16 Jun 2006 03:30 GMT7
I am trying to check it a item is new. Comparing two columns (900-1500 records)
I using IF(ISNA(LOOKUP(A2,G$2:g$1474)),"","Match")
But match is not being returned for any records
sample of data
Use of IF function16 Jun 2006 01:10 GMT4
I want to use the IF function more than 7 times. Can anybody tell me how to
do it ?
Filter formula15 Jun 2006 23:59 GMT4
I have a autofiltered table with many columns.
I would like to display which columns are filtered (and the criteria used)
in cell A2. Is there a formula that returnes the filters used?
Regards
#N/A in mode worksheet function15 Jun 2006 23:55 GMT3
Can anyone telle me when #N/A occurs as the answer to an worksheet
function?
If I try to find the mode of the list of codes below, I get #N/A
7372
Adding category totals15 Jun 2006 23:47 GMT3
Hello Thanks for reading.
I have 2 columns one has the Category and the other has the Time spent
Example:
A1=15        B1=Email
Excel: want neg numbers to show red/pos green via if-then formula15 Jun 2006 23:24 GMT3
I am trying to have the negative numbers in a cell turn red and positive ones
turn green as the values change.  I would like a formula that says "If number
is negative, display text red" and "If positive then display green."  
I know you can make negative numbers red in options, ...
Intersection of row and column based on input15 Jun 2006 23:21 GMT5
I have a problem. I am trying to get a function to return a value from a
table on a different worksheet. Here is a small example of my spreadsheet:
Table with Data Keyed in called Input Sheet:
           May-06   Jun-06   Jul-06   Aug-06
Excel should let me set print gridlines as a default15 Jun 2006 23:17 GMT1
I want gridlines to print on nearly every Excel worksheet so want to make it
a default option.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 215 Jun 2006 22:29 GMT3
hi there i am really in a delima here i want to copy cell C1:C10 (which is a
formula and displayed vertically) into SHEET 2 in a horizontal format,
so at the end if i make any changes in sheet 1(vertical) it should be
displayed automatically in sheet 2 (horizontal) can anyone ...
Have a worksheet = cell value (Time!B2 vs C2!B2 when C2 = Time)?15 Jun 2006 22:22 GMT4
How can I set the worksheet I am referencing in a formula to be the text in a
cell? I have many worksheets with the same formatted data. If I am able to do
this I can pull the data I need from each worksheet without retyping my
formulas by just referencing a row of worksheet ...
How to spread 15,000 into 12 months at 10% ?15 Jun 2006 22:12 GMT1
I want to know how to plan payments with monthly interes rates.
If I borrow 15,000USD at 10% interest annual, what is the formula on a
spread sheet? I have Office 2003
Pls advise, thx
how to calculate the area under the curve in the excel?15 Jun 2006 22:02 GMT2
how to calculate the area under the curve in the excel?
 
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.