|
|
4weeks by
Winston
Hi all
I need to calc the following left to right from start date per day
If day = last day amount stated in cell = 4 weeks then amount is
shown?
The...
|
February 3rd, 2006 08:43 AM
by Max
|
5 |
162 |
|
|
52 Work sheets (Tabs) by
Mike
I have 52 work sheets named week 1 to week 2 once data is completed for each
week is it possible to have the tabs change colour automatically to indicate...
|
|
5 |
242 |
|
|
6 cells of Name and Address by
TAP
I need to combine six columns of name and address information into one cell.
I'm using =J2&" "&K2&" "L2&....etc. With an ALT+Enter between each to line feed...
|
May 17th, 2004 10:26 PM
by TAP
|
2 |
437 |
|
|
640-801 FreeExamKing by
Raj[_7_]
640-801 FreeExamKing
Hello,
Click here to download latest questions and answers brain dumps for
actual and real exams. Almost every certification...
|
|
0 |
139 |
|
|
86 Hosting Web www.ivys.es by
tesddalws
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web www.Ivys.es
Hosting Web...
|
|
0 |
148 |
|
|
9 different timzezones by
Bart Cuenen
Hey guys,
I need some major help here. I want to make a table off hours that our friends can be online for assistance but the problem is that I need to make...
|
|
5 |
152 |
|
|
|
|
0 |
170 |
|
|
= Text formula problem by
Linda RQ
Hi Everyone,
I am using an excel spreadsheet as a linked table in an access database for
an update query. I had it working very nicely for a period of time....
|
December 14th, 2007 08:14 PM
by Linda RQ
|
2 |
146 |
|
|
='DataEntry '!K29 by
HFC-SC
I am trying to copy a cell on Sheet 2 onto Sheet 1 and all I get is the
formula not the text. Help please?
|
|
3 |
108 |
|
|
=combin function by
Jerry Kinder
Hi,
I want to know the combinations of four letter that are possible from a list
( abcdefghij ) .
The =combin function will tell me how many combinations are...
|
February 25th, 2006 02:53 AM
by Max
|
3 |
160 |
|
|
=combin function by
Jerry Kinder
Hi,
I want to know the combinations of four letter that are possible from a list
( abcdefghij ) .
The =combin function will tell me how many combinations are...
|
February 24th, 2006 10:47 PM
by gls858
|
2 |
136 |
|
|
=countif(with two set of ranges; "0") by
Jontie
This is my formula =COUNTIF(E11:E18;"0") I also need to add in range
of E23:E50 I am not sure how to do it or is it possible to do. thanks
in advance for...
|
December 16th, 2007 10:42 AM
by Jontie
|
2 |
136 |
|
|
=D4 problem by
NewMan84
Hi, I'm trying to make a sign in/out spreadsheet that will automatically
fill out our time sheets. My problem is, the cell I am mimiking is
blank, either...
|
|
1 |
117 |
|
|
=DATEDIF(A15,TODAY(),"m") by
Ron
Hi
=DATEDIF(A15,TODAY(),"m") gives the number of months, from a date in the
past, in A15. How can I get the number of months from A15 to say...
|
|
3 |
96 |
|
|
=if formulae by
Janie
I have and excel spreadsheet which I wish to record an error message if one
cell as a value of more than zero and the cell below it has a value of zero.
I...
|
|
2 |
815 |
|
|
|
|
1 |
102 |
|
|
=if(h1800;e180-$j$1;0) by
paulrm906
=IF(H1800;E180-$J$1;0)
H180 = empty cell with a formula in it.
E180 = the date a person was interviewed.
$J$1 = =()NOW
In the above formula H180 is an empty...
|
February 19th, 2006 03:42 PM
by CLR
|
9 |
172 |
|
|
|
|
1 |
142 |
|
|
=SUM question by
John Smith
New to excel.
Can I use a =SUM formula to add a column of times. eg 12:15+03:30+10:00 and
have the answer in fractions...in this case 25.75
Thanks
|
November 23rd, 2004 04:53 PM
by LanceB
|
2 |
126 |
|
|
|
|
3 |
219 |