|
|
|
|
2 |
96 |
|
|
Ignoring formula results of #N/A by
Capt. Bangs
I am working on a time-based spreadsheet (each row represents one period) and
have written a formula that refers to data from a previous row, but I want
the...
|
|
1 |
77 |
|
|
|
|
4 |
216 |
|
|
Tracking information sheet by
Juliebee
I am creating a sheet for tracking outcomes. I want to put the information
into the sheet with a due date for outcomes. e.g data entered ,
outcome due when...
|
|
2 |
85 |
|
|
Help with SUMPRODUCT Function by
MattyP
Hello -
I'm in need of some help. I need to count the number of occurences (rows)
in a Worksheet, based on two criteria (column entries) in that row.
I've...
|
|
6 |
112 |
|
|
SUMIF partial string criteria by
Fred Holmes
SUMIF(range,criteria,sum_range)
Where string (cell formula) criteria is tested against the string in
the "range". This test is a full string comparison.
How...
|
|
4 |
111 |
|
|
|
|
3 |
75 |
|
|
Worksheet with most rows by
Jack Deuce
I have a workbook containing 100+ sheets. Is it possible to find
which sheet has the most rows? The data columns in these sheets
contain dates, coin grades...
|
|
3 |
78 |
|
|
incremental step by
Jim
how do I set up and cell for incermental steps by 1 each time a spreadsheet
is opened for quoting?
|
March 21st, 2009 07:45 PM
by Mike H
|
2 |
103 |
|
|
|
|
1 |
76 |
|
|
|
|
10 |
156 |
|
|
Using MATCH or ......? by
timgiaiphap
Hi all of you,
I need your help. I have a sheet with the follwonig data
TABLE 1 TABLE 2
INDEX Q'TY PRICE TOTAL INDEX Q'TY TOTAL AVG
1 100 2 200...
|
|
2 |
97 |
|
|
XIRR problem by
Dkline
Below is the schedule that I am dealing with. The problem is that I cannot
find a rate that does not return a #NUM!. I've tried both negative and
positive...
|
|
5 |
78 |
|
|
|
|
5 |
90 |
|
|
If Then with Today formula by
JimG
I am trying to subtract one date from another using the Today() formula, but
if the value is greater than 250 I want to return the value of 0.
Can someone...
|
March 21st, 2009 12:37 PM
by JimG
|
7 |
150 |
|
|
|
|
4 |
85 |
|
|
|
|
1 |
69 |
|
|
Can Autofill be used for Hyperlinks by
BushyII
When I create a hyperlink, to a cell in a distant column, on the same
row, it works perfectly. However, if I try to then Autofill it down a
range of rows the...
|
|
2 |
114 |
|
|
Conditional formatting by
Norfolk Bill[_2_]
Help needed with Conditional formatting
I have a spread sheet containing 10 major columns and 240 rows. The data
shown is meteorological values relating to...
|
|
2 |
72 |
|
|
restricting access using a macro by
Popeye the powerman[_2_]
hi there,
Does anybody know of a method for restricting access to a workbook based on
a list of people.
My problem is I have a workbook that two groups of...
|
March 21st, 2009 07:16 AM
by Joel
|
3 |
91 |