move one cell up from result cell

  • Thread starter Thread starter DKY
  • Start date Start date
D

DKY

I have a sheet that has total monies at the end of every month. The
Month's (January, February, March, etc...) are in row 192 whereas the
totals for the months are right below them in row 193. I figured out
how to find the lowest of all the totals by placing the following in a
cell.

Code:
 
=INDEX(B192:AI192,MATCH(MIN(B193:AI193),B193:AI193,0))

--
Regards,

Peo Sjoblom

(No private emails please)
 
Thanks, it looks simple yet complex. Whatever its worth though, it
works beautifully. Thanks again
 
Back
Top