|
|
|
June 22nd, 2009 09:19 PM
by kool
|
4 |
200 |
|
|
SumProduct by
judith
I know that there are loads of similar questions posted but I just dont seem
to be able to figure this out.
I am trying to use
=SUMPRODUCT('order...
|
June 22nd, 2009 09:12 PM
by Steve
|
3 |
142 |
|
|
Autofill Colour by
Kanmi
book1.xls has update link to the database through "function query" mean
whenever there is changes in database file book1.xls automatically run update
it...
|
June 22nd, 2009 09:09 PM
by Kanmi
|
2 |
115 |
|
|
|
|
2 |
127 |
|
|
|
|
2 |
117 |
|
|
sumproduct issues by
Steve
morning all.
Ok, I'm using sumproduct for a specific problem and I'm getting back a
miniscule value of 5.17E-13 as my difference.
The equation is:...
|
June 22nd, 2009 08:02 PM
by Steve
|
2 |
102 |
|
|
varying a cell and seeing the outcome by
mikebo
I am a fairly regular user of Excel and I can find my way around, but now I
have question that I need help on. I have set up a fairly complex sheet that...
|
June 22nd, 2009 07:04 PM
by mikebo
|
2 |
163 |
|
|
Autofill issue by
Jean
I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to...
( 1 2)
|
June 22nd, 2009 06:17 PM
by Jean
|
10 |
196 |
|
|
Time management by
OKY
Hello,
I have a new job and to make it easy I need to have a worksheet where I can
track my service technicians.
In other words we have technicians who are...
|
June 22nd, 2009 06:10 PM
by Luke M
|
1 |
104 |
|
|
Automatic Colour Control by
Kanmi
book1.xls has update link to the database through "function query" mean
whenever there is changes in database file book1.xls automatically run update
it...
|
June 22nd, 2009 06:08 PM
by Kanmi
|
0 |
87 |
|
|
|
June 22nd, 2009 05:37 PM
by Luke M
|
1 |
94 |
|
|
Auto update between two workbooks by
Kanmi
Wow! You are Amazing creator. Thanks so much. It working. I apply it to just
one cell and it working but I want apply it to the rows without changing the...
|
June 22nd, 2009 05:28 PM
by Gav123
|
1 |
102 |
|
|
Excel "Exact" Function by
Bryan Gnidrah[_2_]
I have a worksheet in which I want to compare the data in one cell (A1) with
that in another cell. The cell which is to be compared against is immediately...
|
|
3 |
113 |
|
|
Auto update between two workbooks. by
Kanmi
I'm working on Excel file called destination.xls then i want to call up
another workbook source.xls to automatic update destination.xls on some rows.
I mean...
|
June 22nd, 2009 05:04 PM
by Kanmi
|
4 |
115 |
|
|
Ranking with duplication and gaps by
Goody
I have a column of number that are in an irregular sequence (e.g., 1, 1, 3,
6, 1, 7, 7, 7, 9). I need a formula that will determine the highest value in
the...
|
|
5 |
139 |
|
|
Validation Data and Looking Up Cells by
FredK
I have created a table that has the following information (example)
Category Contractor Address1 Address2 Phone Number Fax Number Estimator
Plumber ...
|
June 22nd, 2009 04:01 PM
by FredK
|
1 |
114 |
|
|
Max Value - based on a time period by
Chris26
Hi
I have a number of data vaules (Col-B) per day for a number of years. Is
there a formula that I could use to extract the MAX value of Col-B for say,
Year...
|
|
3 |
119 |
|
|
|
June 22nd, 2009 03:53 PM
by Kanmi
|
3 |
101 |
|
|
|
June 22nd, 2009 03:10 PM
by Scott A
|
8 |
163 |
|
|
Locking data between worksheets by
mamorellana
I have an excel 2003 worksheet (main) linked to several worksheets
(secondary).
I want to retain the actual values in the secondary worksheets whenever I...
|
|
0 |
106 |