Link to home
Start Free TrialLog in
Avatar of NAB015
NAB015Flag for United States of America

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
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Hello,

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
ASKER CERTIFIED SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of NAB015

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.
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