|
|
Remove color when printing? by
Randy Starr
I have spreadsheets that have multiple cells with color
backgrounds. The cells vary on each sheet. Is there
anyway to print the spreadsheets with the color...
|
|
2 |
194 |
|
|
VLOOKUP question by
AlexD
I need to work with two Excel books. The first MainBook
consist of a list of products (different sheets with
around 100 rows - the first column is the list of...
|
April 12th, 2004 06:29 AM
by AlexD
|
0 |
194 |
|
|
Future value calculation formulas by
nemo_
Hi all,
I am having problems in future value calculations
does any one know the actual formula used in excel for calculating
future value.
Thanks in...
|
April 22nd, 2004 07:45 AM
by nemo_
|
0 |
194 |
|
|
countif for multiple variables by
dwiener
I have two columns with text variables. I need a formula
to count the events where specified conditions for column
1 and column 2 are met. For instance, if...
|
|
1 |
194 |
|
|
Hide Rows <> Today() by
ddionne
Is anyone familiar with a method of "hiding" rows that do not have a
date value = today() ?
I would settle with being able to change the "Fill Color" of all...
|
July 15th, 2004 03:18 PM
by lance
|
2 |
194 |
|
|
|
|
1 |
194 |
|
|
actual row number by
climate
I have 63 file.
My data set on to column X, and G2 is row number related to column X.
I need to macro or formula, when run it on any file, copy of column X...
|
March 17th, 2010 07:59 AM
by climate
|
3 |
194 |
|
|
|
April 21st, 2010 05:29 PM
by Mike H
|
1 |
194 |
|
|
Vlookup formula by
iv
Hello,
I'm using the following Vlookup formula:
=IF(ISNA(VLOOKUP(A4,'S:\Operations\Bloomberg\Investment Support\Dummies2Live\2010\May...
|
|
1 |
194 |
|
|
Sub-Totals on Every Page by
James Duncan
Hi there,
I'm trying to develop an Invoice in Excel that displays
page sub-totals on every page. However, every Invoice
will have a different number of pages...
|
|
3 |
194 |
|
|
Re-post Formula Question by
Syd
I have this formula: =IF(B11"",SUMPRODUCT(--(Events!$A$10:$A$311=B11),--(Events!$B$10:$B$311+Ev
ents!$C$10:$C$311='General log'!Y11 + 'General...
|
|
1 |
194 |
|
|
filtering 2 Excel sheets by
mike
Does anyone know how to overlay 2 spreadsheets and get the
unmatched data????
for example..column a has 200 items on 1 sheet
column a has 100 items on...
|
|
1 |
194 |
|
|
SUMIF Formula by
Ed
Why wouldn't this formula work? The value of A6 is Oct. What I am trying to
do is summarize on my 'Summary' page some transactions by month. The dates
for...
|
|
1 |
194 |
|
|
MEDIAN function by
Mr. Bill
I need to select a series of values from a spreadsheet
based on a text criteria in the same spreadsheet and then
calculate the MEDIAN for those values...
|
|
1 |
194 |
|
|
Trying to create Database / Piviot tables by
alexzagrant
Good day,
I need help. I can't seem to get anything to work. I'm a beginner I
know, but I have tried the Filters using criteria, Piviot tables, and
some other...
|
|
0 |
194 |
|
|
how to write a new macro by
Scott
Hi there,
i already have a macro which grabs required date from a folder on my
machine, and places it into a spreadsheet called mydata, it also sorts the
list...
|
December 4th, 2003 01:38 PM
by Scott
|
7 |
194 |
|
|
|
February 4th, 2004 03:17 AM
by Mike
|
2 |
194 |
|
|
naming by
peter
Hi,
Is there a way to name cell d21 salary in all sheets in a
workbook so that if you type =salary on any sheet it would
return the value in d21 of that...
( 1 2)
|
|
15 |
194 |
|
|
Growing data between 2 points by
Nicky
Can anyone help?
I want to grow data between 2 points on a spreadsheet from a known start point (e.g JAN) to a known finish point (e.g DEC).
Is there a...
|
|
1 |
194 |
|
|
if-then statements or functions by
Becky
I have a 2 sheet workbook. If cell 'sheet1 b7' has a certain word typed into
it I want 'sheet2 b2' to return the value in 'sheet 1 b8'. Can I do this?...
|
May 14th, 2010 08:21 PM
by Nadine
|
3 |
194 |