Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with equation
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 |
#2
|
|||
|
|||
If you have your values 365 ... 30 in cells B2:B6 and your values you are
calculating on in cells B9:B13 you can use the following formula to find the value you are after: =OFFSET(B1,MATCH(MIN(B9:B13),B9:B13,0),0) Andrea Jones www.allaboutoffice.co.uk www.stratatraining.co.uk www.allaboutclait.com "mkerstei" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help with #N/A in equation | Excel Discussion (Misc queries) | |||
Averaging/Rounding Equation Problem | Excel Worksheet Functions | |||
Averaging/Rounding Equation problem | Excel Discussion (Misc queries) | |||
I have a long equation which I need to repeat 16 times! | Excel Worksheet Functions | |||
Logarithmic Trendline Equation | Charts and Charting in Excel |