|
|
Pivot tables & Dynamic Ranges? by
Me!
Hi,
Does anyone know if pivot tables can be based on dynamic ranges (defined
with OFFEST/COUNTA)? as I've tried but can't seem to get it to work.
Many...
|
|
2 |
172 |
|
|
Printing non-contiguous rows at the top by
Rich Burt
Using the 'rows to repeat at top' field of page setup, is there a way to
print non-connected rows (i.e. rows 1, 2, 5, & 6)? The formula only allows
for...
|
|
1 |
135 |
|
|
Goal Seek returning different results by
Don Kline[_2_]
I am using Goal Seek to determine an interest rate for an investment stream
that returns a zero. The investment is irrgular in amount but the period is...
|
|
3 |
189 |
|
|
|
|
1 |
183 |
|
|
Hidden Background Data File by
PSM
Can you get Excel to open another Excel file linked to the first automatically (preferably hidden and read only) in the background ?
|
|
1 |
130 |
|
|
If functions by
Muskrat24
I want to set up a formual so that if H12 is yes, I
want G12 equal to B11, If it is No i want it left blank, is that possible to
do?
|
|
2 |
135 |
|
|
Using Functions by
Muskrat24
I am trying to make a function so that if the cell is "yes" that it will be
equal to another cell and if it is "no" than it is left blank. How do I do
this?
|
|
4 |
172 |
|
|
|
|
1 |
176 |
|
|
Hyperlink function not going anywhere by
rel
I am using Excel 2007, but sharing document with 2003 users.
I have a master list of ingredients on SHEET1. I have inserted hyperlinks to
MSDS files located...
|
|
1 |
118 |
|
|
VLOOKUP format issues? by
Craig4321
I am using the VLOOKUP function in Excel (office 2007) and it is not working
for me. I checked the forums and they had the usual things to check: remove...
|
|
4 |
168 |
|
|
|
|
2 |
125 |
|
|
|
|
5 |
152 |
|
|
Sumproduct by
ronnomad
Having 'brain freeze' with sumproduct...my formula is:
=SUMPRODUCT(--L2:L306=$L309)--(N2:N306=N$308)
column 'L' is a list of departments (and I can list as...
|
|
3 |
117 |
|
|
Formulas refuse to update by
spartina_patens
I am using Excel 2003. I type in a simple formula and all I get is the text
(i.e. =sum(D2:D43)) that I typed in, not the value. I have tried using F9
and...
|
June 15th, 2009 05:54 PM
by Luke M
|
7 |
107 |
|
|
Keeping row number after inserting lines by
MurrayBarn
I have a spreadsheet that has twelve sections (ie one per month of financial
year). In each section there is data pasted in from another worksheet and
below...
|
|
4 |
122 |
|
|
Rounding in Excel by
Al Charbonneau
I have a table that has numbers "hard coded" back to another spreadsheet in
the workbook. Excel says that the numbers (961+73-60=974) in the table. ...
|
|
2 |
92 |
|
|
repeated numbers or value by
soodddddddddd
I have data in 45 coulmns and 3000 rows. I want to know which numbers are
repeated in each row or coulmn.Please help me to solve this problem.
|
June 15th, 2009 03:46 PM
by sood
|
2 |
100 |
|
|
Stock Calculation by
Shah Alam
Suppose,
ProductionDate Production Op Balance DelDate Party Qnty Cl.
Balance
1.1.09 500 500 ...
|
|
1 |
100 |
|
|
Reminder by
Vinod
Is there any provision to generate a reminder on my excel sheet for a
particular date?
eg:
Date A value Previous Date ...
|
|
2 |
126 |
|
|
Linking Date with a Worksheet by
Vinod
Can you pls tell me how the present date in my computer can be linked with a
worksheet?
Or Is it possible for me to set a reminder on my work sheet based on...
|
|
1 |
109 |