|
|
|
|
4 |
78 |
|
|
|
|
1 |
82 |
|
|
Can't figure out a formula by
Dolphin
Here is the problem. I have members (over 900) in my spreadsheet that have
taken annual classes on different dates throughout the year Each class is due...
|
|
1 |
86 |
|
|
Indirect(NamedRange) inside Sumproduct by
Barb Reinhardt
I'm trying to do this, but am having difficulty. Is it because my names
ranges are dynamic using Offset to define them? I'm guessing my only
alternative...
|
|
1 |
64 |
|
|
|
|
5 |
134 |
|
|
Can you subtotal data in rows? by
hdf[_2_]
I know the subtotal function will not work with horizontal ranges. My
question is what can I use to substitute it?
I have a horizontal output data table,...
|
|
8 |
105 |
|
|
Changing Multiple Formulas by
stevieboy1313
We are working with some pretty good size worksheets that have multiple
formulas. How can I change a reference in several formulas all at once,
without...
|
|
1 |
104 |
|
|
|
|
22 |
399 |
|
|
link from other source file is not working by
karen-acctg
File 1 has a trial balance on it for May08
File 2 has a trial balance on it for June08
File 3 has a trial balance on it for July08
Separate File 4 has 3...
|
|
2 |
77 |
|
|
|
|
3 |
96 |
|
|
Modify a Formula by
carl
I am trying to modifythis formula so that it will return "NA" if the value in
B24="NoAction"
=IF(IF(Q24="Buy";S24-AG24;AE24-S24)=0;"Yes";"No")
Thank you in...
|
|
1 |
53 |
|
|
How do I link with certain aspects? by
akemeny
Ok... here's what I need to do. My company has MANY spreadsheets, currently,
that house our data. We record all aspects of our project in Excel and run
all...
|
|
1 |
85 |
|
|
sumifs criteria by
Ebisu-A
I am trying to sum data using the sumif function =SUMIF($A$1:$A$714,
"=396??.50", $B$1:$B$714)
(Criteria range, criteria, sum range)
The criteria range isan...
|
|
3 |
115 |
|
|
Excel Formula using colors by
Powell
A while ago, I was able to write a formula that allowed me to use the "if"
function to format a cell a specified color. If the condition of the if
statement...
|
|
1 |
68 |
|
|
Uploading ASCI by
HeadStart in Word
I am trying to upload an ASCI file from EVOLUTION and I want the column headers
to run down the left hand side of the page not across the top - is there a
way...
|
|
1 |
59 |
|
|
Sumproduct/SumIf by
T
Would appreciate help with the following: Sum column B where name in A:A =
A1 and B:B 10.
Result for John should be 9. Once formula points to Mark, his...
|
|
5 |
60 |
|
|
IF Formula Help Please by
Joe Gieder
Fist, thank you for your help.
I have this array formula in Z2:
{=IF(AND((AG2)="S",(AH2)="S"),"Y",IF(OR((AG2)="U",(AH2)="U"),"R",IF(AG2:AN2="S","G","R")))}
but...
|
|
4 |
69 |
|
|
Sorting columns alphabetically by
SueG
I have a spreadsheet that has names starting in B2 through DH2. I want to
sort B2 through DH2 alphabetically, while keeping the information through row
108...
|
|
3 |
74 |
|
|
|
August 25th, 2008 06:52 PM
by FSt1
|
1 |
83 |
|
|
Workbook will not update after pasting data by
Gina[_3_]
I have a workbook where one worksheet holds the raw data the multiple other
sheets reference in calculations. I left this workbook empty as I pulled out
and...
|
|
2 |
89 |