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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Formula20 Sep 2006 23:58 GMT2
I am working on a spreadsheet that has a column where people will enter in
the date they completed a class, then the next column has a formula in it to
show them when they need to take the class again (Every 2 -3 years). If the
completed column is blank, then I need the due next ...
Format data in History Sheet in Excel20 Sep 2006 23:52 GMT1
I have a history sheet to track changes to an excel spreadsheet.  It
works fine except the date and time field are not formatted correctly.
Of course when I try to change the format to make it read like a normal
date and time it says the sheet is protected.  Is there anyway to
Duplicate entries20 Sep 2006 22:27 GMT3
I have a large spreadsheet consisting of about 16,000 rows and 8 columns.
The first columns are longitude and latitude coordinates.  Is there a way to
sort and display the rows where both the values in columns A and B are the
same?  I have sorted on A then B but sometimes places ...
How do I center align a title at top of sheet.20 Sep 2006 22:00 GMT1
Could someone tell me how to center align a title at top of a worksheet. I've
read the help instructions but it isn't working. I'm using Microsoft Office
2003.
            Thank you
Lookup Formula?20 Sep 2006 21:39 GMT5
I'm trying to come up with a lookup formula for the following example:
          Column A     Column B
Row 1     22k                b22kcw
Row 2     23k                bf23kc
Birthday Calculations20 Sep 2006 21:39 GMT1
I am looking for a formula to do the following.
I have a cell that has a date in it.  Example:  09/15/2006
I have a person I want to be specific age.  Example: 12 years old
I have the person's birth Month and Year:  Example 12/31
OK tough one !20 Sep 2006 21:11 GMT4
I am trying to make dynamic ranges that change as a list changes the
ranges fall in parts of the list.  I use this custome function:
Function Nth_Occurrence(range_look As Range, find_it As String, _
    occurrence As Long, offset_row As Long, offset_col As Long)
Keeping Text format20 Sep 2006 21:08 GMT3
I have a column of data that is in text format:
ex:      
'0215
'6251
excel hyperlink to stock page20 Sep 2006 20:53 GMT1
in my excel page, i have a stock portfolio.  i would like to open this file
daily and have the current stock quote appear without having to go to the web
site.  how can i link that cell to the current stock price.
- sign help20 Sep 2006 20:39 GMT4
how do i create a formula that copy the cell from above inserting a minus
sign before the number? Thanks for your help
adding several worksheet cells onto a main worksheet20 Sep 2006 20:07 GMT2
Hello, I asked this question a few days ago and someone answered me and it
worked but by looking at what I needed it seems to be more extensive than
antisapated so I need assistance. Ok, I have a workbook with several
worksheets in it, each worksheet is set up the same. I want to ...
Vlookup and Values20 Sep 2006 19:54 GMT1
When using vlookup - if the column is empty, I receive a value of "0"
in some cells (I assume this is due to the type of data in the cell),
but I would rather receive a "blank" cell. How do I modify the vlookup
calculation to return a blank if the originating cell is blank?
Can Excel Adress Envelopes?20 Sep 2006 19:52 GMT1
I do not be able to print out envelopes from my excel databace. Is it not
able to be done? Or is there a way that I don't know about?
By selecting cells adjacent to cells tally sheet20 Sep 2006 19:09 GMT2
$6,980    x
$11,880   
$4,900    x
By putting an "X" in a cell adjacent to a number in a different cell is
Inverse Table Lookup20 Sep 2006 18:40 GMT4
Excel Lookup functions normally return a Table value based on a row,column
search criteria. I need to return the row, column based on the table value.
Any ideas Appreciated,
Thanks in Advance
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.