Minimum in which year?

  • Thread starter Thread starter RK
  • Start date Start date
R

RK

Hi! I have a spreadsheet containing financial projections and ratios for a
10-year period. For each year, a particular ratio is measured. I have
determined the lowest value of this ratio over the 10-year forecast period
(using the MIN function). How do I now determine in which year this minimum
value occurred?

Thanks.
 
Hi RK

depends a bit on how your worksheet / book is designed but assuming that you
have the year headings in cells B1:G1, the values associated with each year
in B2:G2 and the minimum value of these years in H2 this formula will give
you the associated years

=INDEX($B$1:$G$1,,MATCH(H2,B2:G2,0))

Hope this helps

Cheers
JulieD
 
Back
Top