|
|
|
June 24th, 2009 03:35 PM
by Max
|
5 |
182 |
|
|
Excel lock / Notify feature malfunctioning by
andrei999
At our workplace we have a master Excel workbook that accessed daily by sales
personnel. Each person has to make entries that they responsible for. Once...
|
|
0 |
125 |
|
|
|
|
4 |
213 |
|
|
|
|
2 |
189 |
|
|
|
June 24th, 2009 02:57 PM
by Steve
|
6 |
130 |
|
|
Conditional programming by
Mark
Hi,
Could you tell me how i can apply conditional formatting rules to all sheets
in a excel 2007 workbook?
Also, can you copy rules from file to...
|
June 24th, 2009 01:55 PM
by Mark
|
0 |
135 |
|
|
Daily compound interest by
Karen
I need to calculate daily compound interest and I tried the following formula
Column A (no of days) | Column B
1 | ...
|
|
2 |
147 |
|
|
Change cell color in protected sheet by
ansa
I have a worksheet where some cells are locked and the whole sheet is
protected. The users should be able to:
1. Enter data into the cells that are not...
|
June 24th, 2009 01:26 PM
by Stefi
|
1 |
123 |
|
|
Financial formula by
Karen
Need some help on a financial formula :
Let's say I have $1,000 in an account. The interest rate is 5.5%pa. If start
date is 10 Mar 2003 and end date is 30...
|
|
6 |
150 |
|
|
Summing Data by Date by
Nigel P[_2_]
I would like to summarise data by date for example
A1 B1 - Date, Value
1/2/9 10
1/2/9 12
2/2/9 34
3/2/9 27
4/2/9 56
with results in another range of...
|
|
6 |
103 |
|
|
Mulitiple Criteria using SUMIF by
Trevor Aiston
I have a data table on worksheet within a workbook which contains a mix of
numeric and text data.
eg a2:a92 containis numeric values of either 0 or 1 while...
|
June 24th, 2009 12:43 PM
by Stefi
|
3 |
121 |
|
|
Excel Maximum viewable numbers in a cell by
Tony
A cell doesn't seem to show more than 16 numers it turns the last 3, in my
case, to zeros. ie 8944456845364785123 is shown as 8944456845364785000. Not
a big...
|
June 24th, 2009 11:14 AM
by Sheeloo
|
2 |
151 |
|
|
|
|
25 |
1,079 |
|
|
|
June 24th, 2009 10:29 AM
by rh33a
|
9 |
249 |
|
|
Sum Multiple Matches by
Mart
Is there a way to sum totals based on multiple matches? Say in the following
example, from a separate sheet, i want to sum up the totals for stationary on...
|
|
5 |
125 |
|
|
Text by
Fareez
hi
Please help me if i type 100 it should come next column in text say hundred.
please not that i want to type cents too say 100.53
|
|
1 |
126 |
|
|
|
|
1 |
133 |
|
|
NETWORKDAYS Worksheet function by
Abhishake Saravgi
The Version installed on my system for Excel is
Microsoft Excel 2002(10.6852.6845) SP3.
I m trying to use NETWORKDAYS from the Example given in the Help...
|
|
3 |
159 |
|
|
|
|
9 |
167 |
|
|
Range - Formula by
VLOOKUP fORMULA
Any one please help me......?
Is there any way to give a formula to a named range.
for example:-
I have given a name Range1 for D10:D20
I need to give a...
|
June 24th, 2009 07:08 AM
by Sheeloo
|
5 |
126 |