|
|
Sum values in one row dependent on a value in a different row by
Mike of Tilford
In Row 5 I have 9 cells with the text value of S, W or R, 3 of each - ie S,
R, S, W, W, S, R, R, W. This is a random order that changes in each table.
In...
|
|
4 |
133 |
|
|
|
September 1st, 2008 06:46 PM
by Ragdyer
|
4 |
189 |
|
|
If function by
Andrew
I am trying to get a formula to work for 3 different scenarios.
Cell R92 can have 3 outcomes:
- If the outcome is 0 the answer should be "Not Completed"
- If...
|
September 1st, 2008 05:31 PM
by Andrew
|
3 |
107 |
|
|
ME, STRANGE SUMMATION by
Berj
Hi,
I can have the number 1 in several cells in a range of cells A1 to Z1, but
it is always filled starting from cell A1 and gradually to the right. May...
|
|
3 |
130 |
|
|
Macro - Whats wrong? by
NPell
Whatrs wrong with this??
I either get an error saying no data, or can not be used with multiple
selection.
Sheets("Data").Select
Selection.AutoFilter...
|
September 1st, 2008 10:51 AM
by NPell
|
4 |
128 |
|
|
Date Format by
TFMR
Dear All,
I have time sheet, which have Date and day columns in day column I gave the
ref. to A1 and change the format to "DDD", It shows the day e.g. Mon or...
|
|
2 |
135 |
|
|
Cell Formatting by
TFMR
Dear All,
I have the time sheet, where one 2nd row is for date, 3rd row for day. 3rd
row is equal to 2nd row and I change the the 3rd row to...
|
|
3 |
98 |
|
|
|
September 1st, 2008 08:06 AM
by TFMR
|
0 |
87 |
|
|
Data Validation Lists by
Steve SME
Using Excel 2003, workbook is multi-paged, previous pages have data
validation 'in cell dropdown' lists. One page will not show the 'in cell
dropdown lists'....
|
September 1st, 2008 06:25 AM
by Max
|
1 |
125 |
|
|
Run macro according to value of a cell by
Kashyap
How to make a macro run automatically according to a value of a cell?
Eq: once we enter value '5' in cell G8, then a particular macro should run 5
times
|
|
1 |
107 |
|
|
Index/Match or Vlookup by
S
I need help to return a cross-reference:
Age/Age 20 21 22 23
20 1.25 1.26 1.27 1.28
21 1.15 1.16 1.17 ...
|
|
2 |
130 |
|
|
PUTTING VBA'S TOGETHER by
confused deejay
hiya after weeks and weeks of research, questions and many answers i've
managed to put an expense sheet together with links and other bits involved
the...
|
|
5 |
112 |
|
|
Row Protection by
Freshman
Dear experts,
In a worksheet, from A2 to E200 is the range for users to fill in. Each row
is an application record and users will fill into it. I will...
|
September 1st, 2008 03:50 AM
by Freshman
|
2 |
105 |
|
|
Auto run macro by
Esradekan
I have an array (B6:J21) that requires a macro being run (sorting
macro) when any figure in the array is changed. How can I run this
macro "on demand"??
|
August 31st, 2008 11:58 PM
by smartin
|
5 |
180 |
|
|
Is a cell a formula or value? by
todd
I'm stumped, I thought there used to be a =isformula to test whether a cell
is a formula or not.
How can I test for that to see if a formula got overwritten...
|
|
2 |
78 |
|
|
Lookup Function Not in Ascending Order by
Jessica Donadio
Is there any other way of going about getting the results that the lookup
function obtains without the list havng to be in ascending order? I have a
pretty...
( 1 2)
|
|
14 |
170 |
|
|
Formatting xl cells by
Brian of Basildon
Does anyone know if xl cells can be programmed to perform "what" or "what
if", "goto", "if", "then" etc
--
Brian of Basildon
|
|
2 |
89 |
|
|
|
|
3 |
132 |
|
|
sumif maybe? by
Esradekan
lets try again.
Column Headers are (B1:P1) Staff 1 Staff 2 etc
A2:A27 is a date range (fortnightly dates range called "Date")
B2:B27 are figures relevant to...
( 1 2 3 ... Last Page)
|
|
30 |
420 |
|
|
|
August 31st, 2008 12:52 PM
by Mike H
|
3 |
93 |