Functions

Array Formula + Indirect Reference
I am trying to do the following two procedures: Procedure 1. Array Formula setting.... for stock analysis. The formula syntax is, =eLink|Bars!'SYMBOL,PERIOD,#BARS,[DTOHLCV],{HEADERS},{HH:MM-HH:MM},{FILL}' Example: =eLink|Bars!'IBM,15,1000,DTOHLCV,HEADERS,09:30-16:00' I have copied the formula into mult... 15 Dec 2009 03:33

IF formula
I so much appreciate having this type of help available as I struggle to learn more about formulas. Thank you to all. Now, in Excel 2007, I have column U that returns a number, but in some cases returns a "NA" (for "not applicable"). I need to add columns U+V+W+X, but need to have the formula ignore the "NA" a... 14 Dec 2009 21:04

proper formula or function
A B C D E AMOUNT INCOME DUE DATE DATE PAID BALANCE 0 If row 1, column D is blank, I want balance to post in Row 2 Column E, leaving R1C blank. is this possible ? Would it require a formula or func... 14 Dec 2009 23:14

function help for counting text as a value....
I have a schedule spreadsheet. i have 7 names in column A starting at row 4 the assignments are in Column B through O representing 2 weeks. (yes i have them labeled too in rows 2 and 3 for day of the week and the date) i can't remember the formula for calculating the assignment as a value of 12. here is a... 12 Dec 2009 06:59

List Disctinct Strings from Range of Cells
Why don u try this. It was in another post. List the distinct strings in one coloumn on a seperate worksheet . match ur main sheet with all the strings against this and make it return yes/no depending on the string matches. Filtering trues will give you only the distinct strings and then do a simple sort.. ht... 10 Dec 2009 23:25

Filtered Counif
really good formulla for filtered countif. Can it work for sumif also? T. Valko wrote: Try 05-Aug-09 Try this: =SUMPRODUCT(SUBTOTAL(3,OFFSET(Q11:Q301,ROW(Q11:Q301)-ROW(Q11),,1)),--(Q11:Q301>249)) -- Biff Microsoft Excel MVP Previous Posts In This Thread: On Wednesday, August 05, 2009 9:06 AM Mr w... 9 Dec 2009 16:40

E2561412.CAB using a 2003 Excel in 2007 Excel
I email an Excel 2003 spreedsheet home from office. I am using 2003 Office at work and have 2007 Professional at home. When I attempt to load it, I am getting a missing E2561412.CAB. How do I correct this? ... 8 Dec 2009 21:58

Remove blank cells from data validation drop down box
First, I've checked out Debra Dalgeish's contextures web site and found some really *GREAT* info there (thank you!). But I'm still having issues with the drop down function using data validation. I have drop down boxes that rely on the value of the cells to the left. I've got it functional with a work around,... 8 Dec 2009 11:57

Showing 0 after decimal with ROUND
Hi, I'm using the ROUND function like this: =ROUND(C29*(92%),1) &- ROUND(C29*(108%),1) Unfortunately, if the numeral after the decimal is a 0, then it doesn't display. How can I force a 0 to display after the decimal? Libby ... 4 Dec 2009 16:18

Can I use AVERAGEIFS?
> Example: A B C D 1 01/10/2009 Cancelled John, Steven 4 2 01/09/2009 Reported John, Steven 2 3 20/10/2009 R... 28 Nov 2009 19:00