|
|
How to repeat cell downwards in a column? by
Fion
For example, the cell I need to repeat is A1 ie MS, the number of times to
repeat is 20 times ie B1 and the result in column C, ie automatically filled
with...
|
January 11th, 2008 01:41 PM
by Richard
|
2 |
96 |
|
|
|
|
3 |
134 |
|
|
PLEEEEEASE HELP by
CC
I've try associate IF OR AND all toghether
like
IF cell A4 1 AND ( cell A5 = "AAA" OR Cell A6 = "BBB" ) Then ...
but not with sucess
I...
|
January 11th, 2008 11:42 AM
by Pete_UK
|
3 |
77 |
|
|
final return! by
via135
hi!
if i make a constant amount of deposit on a periodical basis for a
certain period at a given rate of interest what would be the final
amount i get.?
for...
|
|
5 |
120 |
|
|
|
|
4 |
222 |
|
|
Excel - disable automatic function by
ekonomija
Hello
How can I disable excel when copying from exp. Cell C4 and past special
formulas into C5 that copy the same cell number exp C4 and not C5.
p.s. –...
|
|
2 |
64 |
|
|
index and match closest by
Mona
example data:
a1 b1 c1 d1 e1 f1
S-213A 10/19/2006 60. 10/20/2006 S-213A
S-213A 11/3/2006 ...
|
|
3 |
87 |
|
|
|
|
12 |
246 |
|
|
|
|
0 |
125 |
|
|
How do I fix a YMD format? by
Frustrated
An Excel file sent to me used a YMD date format.
Since then, all my old and new Excel files default to the YMD format.
Selecting a cell, a cell range, or a...
|
|
2 |
69 |
|
|
|
|
1 |
76 |
|
|
INDIRECT & SUMPRODUCT QUESTION by
MESTRELLA29
SUMPRODUCT(--(YEAR('Budget Expense'!$D$3:$D$10393)=$A$1),--('Budget
Expense'!$E$3:$E$10393=D$2),--('Budget Expense'!$J$3:$J$10393=$A19),'Budget...
( 1 2)
|
|
11 |
186 |
|
|
|
|
3 |
97 |
|
|
transferring data between sheets by
The working poor
Here is my conundrum:
I am trying to make a list with five fields such as:
Person : Dollar Amount : Date : Type
On a seperate sheet in the same workbook I...
|
January 10th, 2008 11:42 PM
by Ag
|
1 |
73 |
|
|
|
|
0 |
84 |
|
|
Autofill Array Functions by
Robert
Hi,
I'm using array functions to calculate conditional sums for attendance by
department, but when I drag the bottom right box to autofill across rows and...
|
January 10th, 2008 10:16 PM
by Robert
|
1 |
69 |
|
|
Copying data based on filter criteria by
no_rhythm
I have a workbook with a series of worksheets (more than 25). I need to do
the following:
For each worksheet 2 through 'n'
Sort/Filter on column M "Impact"...
|
January 10th, 2008 09:45 PM
by JP[_5_]
|
1 |
91 |
|
|
Moving Info from onw sheet to another by
Mike
Hi All,
I am trying to use 1 sheet for my data storage then sort that info to
another sheet that looks only for a value I am looking for. Here is a example...
( 1 2 3)
|
January 10th, 2008 09:27 PM
by Mike
|
23 |
238 |
|
|
Linking text by
krc547
How can I link text to a cell reference?
Depreciation Asset - Cell D4
|
January 10th, 2008 09:23 PM
by JP[_5_]
|
3 |
75 |
|
|
Highlight a cell with a specific word in it by
Soulscream
Hi,
I'm trying to highlight a cell using CONDITIONAL FORMATTING if the cell has
the word "Repair" in it anywhere. Example: "123456 - REPAIR" will be in the...
|
|
5 |
84 |