| Thread | Last Post | Replies |
|
| Formula | 20 Sep 2006 23:58 GMT | 2 |
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 Excel | 20 Sep 2006 23:52 GMT | 1 |
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 entries | 20 Sep 2006 22:27 GMT | 3 |
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 GMT | 1 |
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 GMT | 5 |
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 Calculations | 20 Sep 2006 21:39 GMT | 1 |
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 GMT | 4 |
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 format | 20 Sep 2006 21:08 GMT | 3 |
I have a column of data that is in text format: ex: '0215 '6251
|
| excel hyperlink to stock page | 20 Sep 2006 20:53 GMT | 1 |
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 help | 20 Sep 2006 20:39 GMT | 4 |
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 worksheet | 20 Sep 2006 20:07 GMT | 2 |
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 Values | 20 Sep 2006 19:54 GMT | 1 |
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 GMT | 1 |
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 sheet | 20 Sep 2006 19:09 GMT | 2 |
$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 Lookup | 20 Sep 2006 18:40 GMT | 4 |
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
|