|
|
|
|
2 |
86 |
|
|
SUMIF formula with non contiguous cells by
Billy B
I have been trying, without any success, to write a SUMIF function using non
contiguous cells and need some help. Here is the formula I am working...
|
|
2 |
107 |
|
|
Importing Data Wizard by
John L[_2_]
Gday All,I have searched your great disscusion group but cannot find a answer
to this question .When I use the Import data wizard some data does not come
,it...
|
|
6 |
143 |
|
|
Multiple results of Unique Values by
VickiMc
Hi Guys!
My Formula looks like this for identifying unique records
=IF(K20,0,IF(COUNTIF(L$1:L2,L2)=1,MAX(J$1:J1)+1,"")).
What I wanted to know is if there...
|
|
3 |
112 |
|
|
Deleting rows or columns by
Darrell
When deleting rows or columns on a work sheet, the information is lost (ie:
#REF) on the connecting worksheet
|
April 16th, 2009 01:56 AM
by Alan
|
1 |
76 |
|
|
|
April 16th, 2009 01:50 AM
by Alan
|
1 |
79 |
|
|
Calculate Interest Rate by
Mark Parent
If I have opening and closing balances, and the number of equal monthly
payments made, can I calculate the 'effective' interest rate?
|
|
2 |
85 |
|
|
|
|
1 |
86 |
|
|
|
|
1 |
101 |
|
|
Adding a pre-fix to each item in a cell by
nasadell
I have a column that contains cells that either have: nothing (blank), one
word, or multiple words separated by commas.
I need to add a pre-fix to each word...
|
|
1 |
85 |
|
|
Help Calculating Time by
tech1NJ
I have a problem displaying the time (minutes) correctly beyond 60 minutes.
Fox example:
B29 = 3/17/09 4:10 PM - cell formated as DATE and TYPE 3/17/09 4:10...
|
April 15th, 2009 10:04 PM
by tech1NJ
|
5 |
85 |
|
|
Calculate Date by
brownmre
Can an add function be tweaked to compute a date value that does not equal a
Saturday or Sunday.
Example:
Start date = 4/17, days added = 2, answer = 4/19...
|
|
6 |
74 |
|
|
|
April 15th, 2009 08:59 PM
by Tessa
|
3 |
66 |
|
|
|
April 15th, 2009 08:56 PM
by Pete
|
2 |
77 |
|
|
Vlookup with multiple workbooks by
Sally
Is there a way to do a VLOOKUP when there are more than 2 workbooks in Excel
? and how?
When I try using this formula I get an error that says "#VALUE!". ...
|
April 15th, 2009 08:44 PM
by Luke M
|
1 |
91 |
|
|
|
|
3 |
60 |
|
|
Pearsons by
skimball
I always get an error message when attempting to do an array for pearsons.
|
|
4 |
78 |
|
|
External reference to a Column by
AshMorK
Hi,
I have the following formula in wb1 that only works when referenced wb is
opened:
SUMPRODUCT(--(MONTH('Histórico...
|
April 15th, 2009 06:51 PM
by AshMorK
|
0 |
57 |
|
|
Confirmation Security by
Babs in Ohio
I would like to send a spreadsheet with one worksheet displayed and a
sign-off on that page. Once the person has signed-off other worksheets with
then be...
|
|
0 |
68 |
|
|
IF Statements by
Ben Joseph[_2_]
I have in my spreadsheet a number for Budget and a space for putting in
amounts spent. I have an IF statement which displays the words "YOU HAVE
EXCEEDED THE...
|
|
2 |
51 |