|
|
|
September 8th, 2008 06:14 PM
by Sara
|
4 |
131 |
|
|
Update by
robzrob
Is there any way to update a workbook (which is getting data from
another workbook) without shutting it down, opening it again and
clicking 'Yes' to the update...
|
June 16th, 2008 11:31 PM
by robzrob
|
2 |
131 |
|
|
Counting in a spreadsheet by
P. Zicari
I am creating a spreadsheet to keep track of how many people sign up for a
particular course. Is there a way that I can get a count of how many cells
in a...
|
|
2 |
131 |
|
|
|
July 6th, 2008 11:05 PM
by dan
|
4 |
131 |
|
|
|
July 16th, 2008 06:48 AM
by Max
|
3 |
131 |
|
|
Nested if using range names by
DianeG
Hi
I know that you can use VLOOKUP instead of IF's to get a result but I'm
trying to get Chip Pearson's example to work. The problem is as follows:
I have a...
|
|
1 |
131 |
|
|
Working with Functions on French Computer by
Cazzy123
Hi,
I have just bought a French computer and can't get the simplest of formula's
to work. I am trying to do an IF or Si statement but it won't work but if I...
|
|
3 |
131 |
|
|
match with isna formula question by
Belinda7237
I want to bridge info from one workbook to a new workbook with a formula in
column V. but i have two criteria instead of one to consider the match before...
|
|
2 |
131 |
|
|
#NAME? by
77Debbie77
I am pulling my hair out!!! I have over 60,000 rows of data with comments and
am trying to add a function to a cell: =SUMPRODUCT(--('Closed calls as of...
|
|
5 |
131 |
|
|
|
|
2 |
131 |
|
|
|
|
1 |
131 |
|
|
|
April 14th, 2008 10:32 PM
by Max
|
5 |
131 |
|
|
Save file as semi-colon delimited? by
Colin Hayes
HI
I need to save a file as semi-colon (;) separated.
Does any one know how to do this?
I can only see tab , space or comma CSV options in the 'save as...
|
April 22nd, 2008 08:21 AM
by Stefi
|
2 |
131 |
|
|
Nesting by
LWilson
I've got a table of data...
Loan number, tran code, acct, amt.
I need to sum the amounts for the loan number that equal a certain tran code
and acct...
( 1 2)
|
|
12 |
131 |
|
|
Complicated working days function by
Chris
I have a start date in F2 and an end date in G2. I am currently using
this formula for the number of working days, which works...
|
|
7 |
131 |
|
|
|
May 5th, 2008 11:57 PM
by Max
|
9 |
131 |
|
|
|
|
1 |
131 |
|
|
|
May 17th, 2008 11:16 PM
by Rick
|
4 |
131 |
|
|
XIRR Problem by
Dkline
I am trying to use XIRR to solve for the rate for a known schedule of dates
and value. That schedule is below. I have solved for the rate using IRR and
also...
|
May 20th, 2008 10:10 PM
by Dkline
|
8 |
131 |
|
|
countif criteria sg by
Fred Loh
i have a column (column B) of cells with numbers in the cells. i want to
count for. example, how many cells have a number between 12 and 29. i used...
|
|
7 |
131 |