Using Time in formulas #2
I don't want the user to enter them by hand. I want to use a formul
to calculate the subsequent times. They would have to load 9
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=107
View this thread: http://www.excelforum.com/showthread.php?threadid=26920
...Outlook 2003 not working in WIN 7 OS
Unable to collect emails in Outlook 2003 on WIN 7 OS. Error message requests
microsoft Agent 2.0 from Office Disk. Tried HotFix from Win 7 Website, but
it didn't work. Need detailed instructions on how to fix this problem.
...How to add more field on My Work
In PWA, as a Project Manager, when I go to Server Setting, then Manage Views
and select "My Work" in order to manage the view of "My Tasks" for any users,
It seems some fields are not available like the "Baseline Finish" or "HREF".
However, they do appear on "Project" for GANT purpose.
As I need to customize My Task view, how is it possible to add this fields?
Thanks for your reply,
P.S I use 2007 SP1, cannot migrate to SP2 cause of many errors with our
1) Check if you can create a new Enterprise D...Help needed on date matching and cell reference.
I need a formula to return the value of a cell from a nearby column, based on
a matching of the months and years within a range of dates to the months and
years within a given date. Here is the setup:
Cell BA58 contains the given date.
Column AP, starting in Cell AP59 and going down to AP2000 contains the array
of dates that need to be evaluated to find which date matches the given date
in Cell BA58
Column AR, starting in Cell AR59 and going down to AR2000 contains the array
of numbers from which the result must be displayed. If a match is found
between the given date in...In cell drop down button disappeared
I have a column with a data validation list.
My drop down arrow doesn't show up anymore when I select the cell.
It has been working for a year with no problem.
Where did it go?
I looked in Tools-Options to see if anything was unchecked, but all looks
If you select the cell and do data>validation is allow list and in-cell
dropdown still there (and checked)?
"lunker55" <email@example.com> wrote in message
> I have a column with a data va...Referencing a referenced cell
Sheet1!C4 contains the formula =Sheet2!A1
I want Sheet1!D4 to find out what cell Sheet1!C4 is referencing an
then return the value two columns over. (Offset will take care o
returning the value two columns over). My problem is I need to kno
which cell Sheet1!C$ is referencing. If I use the formul
"=OFFSET(Sheet1!C4,0,1)" I get the value from one column to the righ
of Sheet1!C4, I need the value of one column to the right of the cel
being referenced by Sheet1!C4, (Sheet2!A1) How would I do this.
Message posted from http://www.ExcelForum.com
see your post in Excel.mis...formula #12
I have about 3000 rows filled with 114 unique items. Out of these unique
items I want few of them only. How can I delete the rest without manually
deleting each one of them. Through Custom Autofilter I can use only two
Thanks in advance.
I don't know your data structure, but you might consider using a Helper
Column and putting some combination of a IF/OR/AND/CONCATENATION formula to
consolidate several cells at once for filtering them as a group.
Vaya con Dios,
"Kirandeep Singh" <Kira...Using Tab key to jump to specific cell
I've created a 'fillable form' and somehow (magically) when the tab key is
pressed in certain cells, the cursor jumps to the next appropriate cell to be
filled (Example I filled in cell B1 and the next fillable cell is D4. If I
hit the tab key after typing in B1, the cursor will jump to D4). But this
does not happen in all cells or at the appropriate places. I don't know how
I managed to get it to do what it does already. Is there is a way to
When you protect a sheet, tabbing will cause the active cell to jump between
the unlocked (aka unprotect...Copy from many cells and paste to one
I need to copy a range of cells (C7:C20) and past the contents into one
cell (B4). the concatenate function is not the solution because I need
the results to appear as separate lines in the cell (B4) when pasted.
(leaving a "return" between lines)
Weird I know but Ahem, "It's for a friend". ;)
eoreality's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24549
View this thread: http://www.excelforum.com/showthread.php?threadid=381448
...Merge two cells together without losing value of one cell
Is there any way to merge two cells together without getting one value
deleted? As an example, I'd like to add ";" after a number, but when I do a
merge the ";" would get deleted. Thanks.
I have 300 cells with numbers to add ";" to.
> Is there any way to merge two cells together without getting one value
> deleted? As an example, I'd like to add ";" after a number, but when I do a
> merge the ";" would get deleted. Thanks.
On Aug 7, 10:00=A0am, Sharon <Sha...@discussions.microsoft.com&g...Formulas not calculating???
My excel is no longer calculating formulas, when referencing other cells.
How can I correct this?
maybe: Tools - Options - Calculate and enable automatic calculation
"J Dizzle Fizzle" <J Dizzle Fizzle@discussions.microsoft.com> schrieb im
> My excel is no longer calculating formulas, when referencing other cells.
> How can I correct this?
...Copy formulas in Column
I have to copy numbers from cell a1, b1,c1...........z1 to a20,a21,a22,a23...
so. for e.g--
a1 = 21
b1 = 23
c1 = 24
z1 = 40
i need to copy as follows:-
a20 = a1
a21 = b1
a22 = c1
Is there an easy way to copy the numbers instead of typing one by one ....
I have many records to copy.....
Thanks for your kind help :)
--Select the range A1:Z1 and copy
--Select cell A20. Right click>PasteSpecial>check 'Transpose' and click OK
> I have to copy numbers from cell a1, b1,c1...........How do I delete cells in Excel without changing the data in others
I want to get rid of some of the rows in my spreadsheet but the data in the
ones I am leaving behind are linked by formulas? As soon as I delete them all
the data goes from the the others.
I may not understand your situation. An example of what I think you're
saying is: Cell A2: A1+1. You want to delete cell A1, but leave A2 with the
value it currently has.
If this is the case, you need to copy A2 and the, using paste special, paste
the value back into A2. This way A2 no longer has any formula at all and
will remain unchanged when you delete A1.
"G...Linking a repeating pattern of non-adjacent cells
I need to transpose an Excel worksheet where every fourth cell is selected
and placed into a single column of another workbook. Can I write a formula
to do this so I don't have to manually copy each cell I need?
If your original data were in col. A, you could put this
in A1 of a new wb:
and drag down. It'll pull in the values in row 1, row 5,
row 9, and so on.
>I need to transpose an Excel worksheet where every
fourth cell is selected
>and placed into a single column of anoth...Excel cell format #2
how can i display preceding zeros in excel without formatting as text?
In article <5CBDC357-B0B2-49C2-906C-73E94C6172B9@microsoft.com>,
"rockfam8" <firstname.lastname@example.org> wrote:
> how can i display preceding zeros in excel without formatting as text?
Precede your entry with an apostrophe. For example...
Hope this helps!
Or give it a custom format like
(as many 0's as you need)
> how can i display preceding zeros in excel without formatting as text?
...Formula for a fill color help
I can't figure out how to make a formula that will recognize a color a
a value. More specifically; If b1 is made to be green (color index 4)
would like c1 to insert the letter Y. I am I'm looking for an I
statement so I can use it throughout the whole workbook.
The formula if I understand it should kind of look like (in C1):
I'm looking to put a "Y" in c1 if b1 is colored in green.
I would really like to also know how to insert a fill color in an
Thank you for any of your help and time,
Yo...vlookup function to return the cell address of the found item
I have a one column list of data (around 3,000 items) - and I am using
the vlookup function to determine if an item is in that list using
something like the formula below:
=if(iserror(vlookup(A1,D1:D3000,1,false)),"not in list","in list")
I would like to know if I can have this function return the cell
address or row number to indicate the location of the item in the list
- is this possible?
Thank you for your time and assistance
You can return the (relative) row number using MATCH, like this:
list",MATCH(A1,...Insert file name into Cell
Is there a way to insert the file name into a cell, rather than on
=SUBSTITUTE(SUBSTITUTE(CELL("filename",A1),"[",""),"]"," [") & "]"
for more information, worksheet examples, and coding examples for
pathname, filename, sheetname and combinations of ...Formula for computing work time in Excel
For instance, A1 = 8:20, B1 = 16:30.
I need to compute in C1 the following: B1 - A1 - 0.5 hour.
What is the formula?
If I use formula B1 - A1 - 0:30 I get invalid value.
email: alex DOT vinokur AT gmail DOT com
"Alex Vinokur" <email@example.com> wrote in message
> For instance, A1 = 8:20, B1 = 16:30.
> I need to compute in C1 the fo...paste value vs type value (formula not working)
I have a formula that works just fine, as long as i paste the values
from the original list and not type the numbers in.
There are no hidden spaces (that I know of), but when I type the same
value that I have in my orignial list, the formula gives me an error
(#N/A). When I copy and paste values (from the original list) it works
(an array formula)
If its an ARRAY Formula, you must press Control-Shift-Enter,
Try it and see
"J.W. Aldridge" <jeremy.w.aldrid...Date when I last change cell in a row?
In my database, every row represents a separate client. I wonder if it is
possible to input the date when I last changed any value in a particular row.
This way I will know when exactly I last updated the information for client
in row 4, 5 etc.
I don't need the date when the document was last saved.
Please, let me know if it can be done in Excel.
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If .Row = 5 Then
Me.Range("H1").Value = Date
...Displaying cell references next to embedded cells in Word 2000
I've embedded some excel cells into my report written in Word 2000. Is
there a way I can display the cell references next to the embedded object
in the printout.
For example if cells B10:C15 are the embedded cells, I want those who read
the printed document to see exactly which rows and which columns the
numbers belong to. Something like this:
10 Jan 10%
11 Feb 15%
12 Mar 34%
13 Apr 14%
14 May 10%
15 Jun 12%
So when I say somthing like "The formula used here is C10/SUM(C10:C15)" my
readers would be able to refer to the ...CRM task button not working???
I can't even open the form in the Personal Forms Library. Is there any way
for me to reinstall this form?
...Average Row Formula
Is there a way to calculate the average of a row if some cells are
empty but when calculating the average they should have the value of
the cell to the left?
If the following data is enterered
A B C D E F G
1 3 5 6
For the calculation the cells should use the data
A B C D E F G
1 3 3 3 5 5 6
Also what would the average formula be if you wanted to skip one of the
cells from the average calculation?
pls do NOT multipost. It wastes resources
"Tom" <firstname.lastname@example.org> wrote in message
news:111546...Auto forward doesn't work for email sent to distribution list
When I sent an email to a distribution list it's not auto forwarded for
people (members of this distribution list) who have there Out of Office
Assistant configured with "forward all messages to email@example.com". For
all other messages the auto forward works fine. Anyone any idea to solve this
Many thanks in advance,
Define "auto forward".
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Lex Haak" <LexHaak@discussions.microsoft.com> wrote in message