|
|
calc by
PH NEWS
Hi all,
I have a spreadsheet with about 20 columns of data, 3 of which are
long-winded array formulas. I have some conditional formats and simple IF
functions...
|
September 22nd, 2006 03:01 PM
by vezerid
|
6 |
51 |
|
|
Formula not copying down by
LizM
I am currently trying to copy a formula down for a total of 734 rows and
across several columns. For some strange reason it stops at 641 rows. Once
I drag...
|
September 25th, 2006 09:44 PM
by LizM
|
6 |
74 |
|
|
|
September 25th, 2006 10:34 PM
by Raza
|
6 |
63 |
|
|
Match with tilda characater by
IanW
Hello all,
I was trying to use the Match function in a VBA module (I hate VBA).
Match was failing unexpectedly.
I evenetually tracked down one issue (using...
|
September 26th, 2006 02:26 AM
by Biff
|
6 |
83 |
|
|
What is wrong with this formula? by
Dan B
I have a spreadsheet with multiple worksheets. I need one sheet called
Customer Lookup to pull data from another sheet called Liability Policy
Expiration,...
|
September 27th, 2006 02:00 AM
by Max
|
6 |
57 |
|
|
|
September 26th, 2006 10:00 PM
by Marcelo
|
6 |
89 |
|
|
index match by
Mark
I am looking for the value when Loan amount is $670,000 with 640 FICO
and LTV 76 and that should give me 3.000
LTV 0 70.01 75.01 80.01 85.01 90.01
Loan...
|
|
6 |
53 |
|
|
Vlookup Frustration by
kevincanuk
Hoping someone can help me with a VLOOKUP problem. I have two simple VLOOKUPS
in my workbook. One works great, the other does not. They are virtually the...
|
|
6 |
48 |
|
|
Convert a text file to columes by
A123BELLE
I'm trying to convert a text file with multiple rows (10) of repeated data.
The "Text to Columns" function in Excel can only sort one row. Is there a way
in...
|
September 27th, 2006 07:50 PM
by Pete_UK
|
6 |
82 |
|
|
|
September 27th, 2006 04:28 AM
by Len
|
6 |
52 |
|
|
Countif & Sumif with Multiple criteria by
Kim Shelton at PDC
1. Countif with multiple criteria. I have tried sumproduct as follows...
=SUMPRODUCT(('Jan 06'!A:A="B")*('Jan 06'!G:G="TRUE"))
but this gives me a result as...
|
|
6 |
61 |
|
|
Array formula and multiplying conditions by
KR
I have a large worksheet and I'm trying to pull some specific information
out of it, and I'm not getting the numbers I expected- so I think there is
something...
|
September 22nd, 2006 12:33 AM
by Epinn
|
6 |
50 |
|
|
count on multiple conditions by
Debbie
I'm trying to perform a count based on two columns and two conditions. I've
searched the forum and found several options but can't get any of them to
work....
|
September 21st, 2006 06:34 PM
by Debbie
|
6 |
45 |
|
|
combination functions in one cell by
Mary S
Hi
I am trying to create a combination function. I want to first sum specific
cells in a column and then if the sum is a certain value, I want the cell to...
|
|
6 |
83 |
|
|
|
September 24th, 2006 01:05 AM
by RagDyeR
|
6 |
61 |
|
|
Take out judges scores by
Pierre
Am totaling scores for each judge for a contest, and each entry is
judged in 3 categories. Need to sum the remaining scores, by tossing
out that judges...
|
September 22nd, 2006 08:31 PM
by Pierre
|
6 |
51 |
|
|
Automotive 5 Year Depreciation by
Jay
Hey Guys:
Can one of yuz take a look at this formula related to a 5 Year Automotive
depreciation factor?
Here it is:
21,000 Initial cost =A12
2,100 Salvage...
|
|
6 |
55 |
|
|
add time by
jfw-Florida
I want to add a column of times in a time sheet. I can get the hours worked
but can't seem to get the column to add totalhours
|
|
6 |
63 |
|
|
Helpful New Functions: ALL and ANY by
Atreides
I'd really like Excel to have an All(range, criteria) function, as used in a
number of programming languages. For instance:
A B C D
1 y y...
|
|
6 |
76 |
|
|
Urgently need help with a formula!!! by
BillOSull
Hello,
I'm badly in need of some help with an excel formula. Essentially I
need to check to see if the value of C7 is "Y" and if so for the
formula then to...
|
September 27th, 2006 09:50 PM
by Dave F
|
6 |
101 |