Functions

Thanks
Hi smartin Thanks for the reply. I don?t really get your formula, as I am looking for the time when the value appears for the first time. MATCH should not start comparing with the first time value, but e.g. 1 hour later. Am I supposed to copy your formula down due to the $-sign? Best regards Michael smartin ... 7 Nov 2009 00:43

IF statement
Is there a way to write an if statement to look at column b and have it check column L with a YES if the name starts with OD? thank you ... 5 Nov 2009 23:26

sumproduct i think
Hello, I'm struggling with what I think requires a sumproduct function but I can't make it work and I'm going cross eyed... I need to count the number of occurences of "x" in column c if the value in column a = "text1" or "text2" but column b <> "text3". -- Any help appreciated, MarkN ... 5 Nov 2009 02:18

cant pass array to excel from c++ using xloper structure
i tried a lot to pass array to excel sheet using xloper structure hear is sample function i wrote to pass array using xloper __declspec(dllexport) LPXLOPER xarr () { static XLOPER xlArray; XLOPER xlValues[4]; int i; for (i = 0; i < 4; ++i) { carr[i]=i*2; xlValues[i].val.num = i+10; xlValues[i].xltype = ... 4 Nov 2009 04:14

Bottom value in a list
Hi, Column D has a list that continuously grows down the column. The list starts in D4. I need the last value at the bottom of the list reported in D1. The values are numbers and the numeric range is 1 thru 31 mixed. Thank-you in advanced. Amy ... 3 Nov 2009 13:47

standard error of regression coefficient
Does anyone know how to calculate this using excel formulas? Sb = Se/sqrt((x-xbar)^2) Where Se = sqrt(sum((y-yhat)^2/(n-k-1))) I imagin it can be replicated with mmult and transpose comb, but am not sure how? Thanks, ... 2 Nov 2009 17:58

Spread numbers by setting up a Min and Max
Hi, If I want to spread the numbers between two cells, lets say A1 is the minimum of something and A5 is the maximum, what's the formula to do this? For example, if A1 is 10 (minimum) and A5 is 100,000 (maximum), by using such a formula, I will have like the following: A2= 100, A3= 1,000, A4= 10,000 Thanks... 2 Nov 2009 09:01

Date calculation
I have an end date in mind for training, and the number of days the training is supposed to last. Is there a formula to determine the start date minus weekends? Example, training must be completed by May 1, 2009, and the training is supposed to last 10 working days, what should the start date be? I'm using Ex... 2 Nov 2009 05:44

VLOOKUP with WORKDAY?
Is there a way to lookup a range of holidays based on a person's name, and then use that range in the WORKDAY function? I have a list of employees and their days off (holidays) and I'd like to use a different range of holidays for each employee. Ideas? -- XLNut ... 1 Nov 2009 09:59

Row to Column
Hello, I have difficult to convert data as follow: Original: Column A Column B Column C Column D Column E Column F China 0.1 86 8610 8620 8621 After (Conversion): Column A Column B Column C China 0.1 ... 1 Nov 2009 01:21