HELP WITH MAX VALUE AND SECOND MAX VALUE IN A NON ADJACENT LIST
Posted by Jiminey Dehey on November 06, 2001 10:00 AM
Help.......I am pulling my hair out trying to get a formula to tell me the max value and second max value in a group of non-adjacent cell on another sheet in the workbook. I tried =MAX(sheet2!al,sheet2!a3 etc.) and that tells me the max value but i need the second largest value also. I tried =LARGE(sheet2!al,sheet2!a3, etc.) but i get an error message........can someone help porfavor.