I have 5 values:
Annual
Semi-annual
Quarterly
Rolling Four
Monthly

Annual = 365, Semi=183, Quarterly=90, Rolling=90, Month=30.

There are 6 rows that can have one of the values in them.

Can anyone help me write and equation that searches all 6 rows, finds
the smallest value, and converts it into its corresdponding number?

ex. If, of the 6 rows, 3 of them had values in them. Annual,
Semi-annual, and Monthly respectively. The equation would return 30,
because Monthly is the smallest value.

Thanks.


--
mkerstei
------------------------------------------------------------------------
mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688
View this thread: http://www.excelforum.com/showthread...hreadid=393077