|
|
|
|
1 |
90 |
|
|
|
August 7th, 2008 11:26 AM
by Dima
|
4 |
114 |
|
|
Working with Functions on French Computer by
Cazzy123
Hi,
I have just bought a French computer and can't get the simplest of formula's
to work. I am trying to do an IF or Si statement but it won't work but if I...
|
|
3 |
131 |
|
|
validation data by
KE
I have set up a spreadsheet which requires drop down boxes with data pre set.
I want to take the validation data from a separate work sheet. Can anyone
help...
|
August 7th, 2008 09:56 AM
by Stefi
|
1 |
82 |
|
|
Using two formulae by
Kirsty_H
I want to use two formulae within one cell.
=IF(A50="",260,NETWORKDAYS($B$4,A50)) and
IF(B50="",260,260-NETWORKDAYS($B$4,B50)) are the general formulae I am...
|
|
3 |
99 |
|
|
|
August 7th, 2008 06:20 AM
by Max
|
8 |
170 |
|
|
Need help creating formula to sum tables by
Darren Ingram
Hi
I have a massive table which has various departments in column C, services
supplied by the departments in column D and the period invoiced in column...
|
|
4 |
100 |
|
|
Error: Undefined or non-rectangular name by
Conan Kelly
Hello all,
(Office 2003 SP3 on Win XP Pro SP3)
(Also tried the following on an Office-2003-SP3-on-Win-XP-Pro-PS2 machine)
Has anyone seen this error before...
|
|
0 |
111 |
|
|
INCREASE COST COLUMN BY A PERCENTAGE by
bill z
i have a spread shee with a column of my product costs i want to mark up the
whole ncolumn by 25%. please help how do i dom this.
bill z.
|
|
3 |
129 |
|
|
Filtering totals - Reps per Province by
jvbelg
I have 3 columns: Provinces, Customer numbers, and list of reps
servicing these customers.
A 7213 3
A 8027 8
A 2230 4
B 3240 3
B 3148 3
B 2370 4
C 3121 3
|
|
6 |
61 |
|
|
|
August 7th, 2008 12:20 AM
by Pete_UK
|
1 |
65 |
|
|
Simple Worksheet Protection by
James8309
Hi everyone,
I am just trying to lock the worksheet so no one can change anything
for all the worksheets.
I have 40 worksheets in a workbook and problem I am...
|
|
2 |
82 |
|
|
Vlookup not returning correct value by
Drebdog
Have a simple VLookup set up to retun a time value for a concantenated
statement since the statement will not display the time in a readable format.
...
|
August 6th, 2008 11:29 PM
by Drebdog
|
4 |
106 |
|
|
|
|
8 |
71 |
|
|
Counting colored cells by
Joebeone
Is there a way to count cells that are a certain color. Like count how many
cells are blue or how many are red
|
|
3 |
65 |
|
|
Counting numbers in an array by
BRob[_2_]
I want to count the number of cells in an array (16x30) that contain a
number rather than an alpha character.
Is there an easier way than do 16 column...
|
|
4 |
85 |
|
|
copy down by
robzrob
B4:B9 is 04/08/08
B10:B15 is 05/08/08
B16:B21 is 06/08/08
B22:B27 is 07/08/08
B28:B33 is 08/08/08
ie Mon-Fri dates, then
B38:B43 needs to be 11/08/08
B44:B49...
|
August 6th, 2008 09:32 PM
by robzrob
|
4 |
58 |
|
|
|
|
0 |
68 |
|
|
Formulas/References by
Josh
I have a spreadsheet where I add a new column every week and therefore have
to change the formulas every week too. The new column is inserted in column
H...
|
|
3 |
62 |
|
|
|
|
1 |
79 |