NAB015

asked on

# Excel formula

Hello experts,

The formula is pretty simple

(Number of 'days' since the highest value - Number of days since the lowest value/ The number of days being examined)

I am thinking of something like:

=(count(offset(A1,0,index(match(max(range))),0)-....)/count(range)

I haven't got anything to work quiet right.

Thanks for the help!

NAB

The formula is pretty simple

(Number of 'days' since the highest value - Number of days since the lowest value/ The number of days being examined)

I am thinking of something like:

=(count(offset(A1,0,index(

I haven't got anything to work quiet right.

Thanks for the help!

NAB

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Sorry for the slow reply. I was working off your sheet when I got the formula working. I was messing up the index(match deal.

Thanks for the help! I got it working.

Thanks for the help! I got it working.

Tell me how I could have gotten a better rathing than "good" given I didn't have your dataset and don't read minds.

:)

Dave

:)

Dave

any chance you could post a workbook, so we can see how your data is laid out? Is "Highest value" the most recent date? Is your data arranged in columns (seeing that you use a column offset).

cheers, teylyn