Hi -
Thanks for any help on this.
I have a spreadsheet that looks like
MATURITY AUSTRIA BELGIUM FINLAND FRANCE
4/24/2006 2.651 0 2.651 2.507
5/18/2006 2.651 2.507 2.651 2.507
7/20/2006 2.779 2.582 0 2.582
10/19/2006 2.932 2.765 2.932 2.765
4/30/2007 3.012 3.198 3.198 3.012
I need help with 2 issues:
1) I need to pick minimum non zero number for a given row
2) I need to know for the minimum as ascertained in 1) , what is the
country eg. for 4/24/2006 - minimum is 2.507 and the country is France
Thanks.
Sangeeta:)
--
sangeeta
------------------------------------------------------------------------
sangeeta's Profile:
http://www.excelforum.com/member.php...o&userid=33826
View this thread:
http://www.excelforum.com/showthread...hreadid=536010