software

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:
--------------------
=MIN(B193:AI193)
--------------------

The problem is that I want to know the corresponding month for that
value, how would I go about doing that?--
DKY
------------------------------------------------------------------------
DKY's Profile: www.excelforum.com/member.php...oamp;userid=14515
View this thread: www.excelforum.com/showthread...hreadid=498931=INDEX(B192:AI192,MATCH(MIN(B193:AI193),B193:AI193 ,0))

--
Regards,

Peo Sjoblom

(No private emails please)quot;DKYquot; gt; wrote in message
news
gt;
gt; I have a sheet that has total monies at the end of every month. The
gt; Month's (January, February, March, etc...) are in row 192 whereas the
gt; totals for the months are right below them in row 193. I figured out
gt; how to find the lowest of all the totals by placing the following in a
gt; cell.
gt;
gt; Code:
gt; --------------------
gt; =MIN(B193:AI193)
gt; --------------------
gt;
gt; The problem is that I want to know the corresponding month for that
gt; value, how would I go about doing that?
gt;
gt;
gt; --
gt; DKY
gt; ------------------------------------------------------------------------
gt; DKY's Profile:
gt; www.excelforum.com/member.php...oamp;userid=14515
gt; View this thread: www.excelforum.com/showthread...hreadid=498931
gt;
Thanks, it looks simple yet complex. Whatever its worth though, it
works beautifully. Thanks again--
DKY
------------------------------------------------------------------------
DKY's Profile: www.excelforum.com/member.php...oamp;userid=14515
View this thread: www.excelforum.com/showthread...hreadid=498931