|
|
|
|
0 |
195 |
|
|
Array Formula Help Needed by
nelly
Hi Guys
I need an array formula which counts the number of instances range Comp1 has
a value greater then zero AND Range Comp2 has a blank value.
Sounds...
|
April 13th, 2010 12:43 PM
by nelly
|
5 |
195 |
|
|
|
April 1st, 2010 11:50 PM
by jj
|
8 |
195 |
|
|
|
April 21st, 2010 05:29 PM
by Mike H
|
1 |
195 |
|
|
Lookup by
Kaisa
A B C E F
1 SKU SUM SKU SUM
2 85 10 85 10
3 86 20 86 20
4 87 30 88 30
5 89 40
I'm trying to make a formula that can tell me the sum of each number....
|
|
3 |
195 |
|
|
|
April 29th, 2010 04:25 PM
by UKMAN
|
4 |
195 |
|
|
Suppress First Page Numbering by
Michael
Hi folks - Is there anyway to suppress page numbering on the first page of
an Excel sheet? Thanks.
Michael
|
April 27th, 2010 08:43 PM
by Michael
|
4 |
195 |
|
|
Yes - No Fill-ins & More by
DisMusBeDaPlaz
Working in Excel, I am looking for help using fill-in boxes.
I am creating a form.
Setting up a cell or a bunch of cells merged where you can enter a...
|
|
0 |
195 |
|
|
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 |
|
|
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 |
|
|
Formula Excel by
Newfie809
Wondering if someone would be able to help me with this:
A B C
Year Year Service
01-Sep-89 30-Jun-10 = 21 Years
Teachers
From September 1, 1989 to...
|
|
2 |
194 |
|
|
|
April 19th, 2010 05:19 PM
by Pete_UK
|
2 |
194 |
|
|
Cash Statement- Accruing balances by
cjarrar
we are attempting to create a Cash Statement report for a single account and
would like to include a To Date, Month To Date and Fiscal Year totals. Is
there...
|
|
1 |
194 |
|
|
|
March 17th, 2010 02:42 PM
by JSAUS
|
3 |
194 |
|
|
Eliminating cells with a zero by
Morton Detwyler[_2_]
I have a matrix of data that lists part numbers in row and serial numbers
in column as shown in Example 1. In the example below (Example 1), the
range...
|
|
7 |
194 |
|
|
Monthly files by
dimitry scharff
I have a monthly files where every day is a sheet, the beginning of which
references a cell on the sheet before. Is there a way of having this done
without...
|
|
2 |
194 |
|
|
Finding the unknown number by
sierra spiegel
I have a list of number:
-17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3
The sum of those number +1 is the answer to the current number, but what...
|
|
6 |
194 |
|
|
|
|
1 |
194 |
|
|
Convert text to rows by
Radrays
I am currently using 2007 - I have about 20,000 rows by 12 columns of
information in a spreadsheet.
Column "G" cells will at times have more than 1 number in...
( 1 2)
|
|
17 |
194 |
|
|
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 |