Formula issue with LARGE and SMALL

Hi Pearlyn,

Here is another alternate solution to the ones already provided. I have attached a sample workbook for you with the conditional formatting for your second problem.

All formulas to be entered using Control+Shift+Enter:

Second Largest Value:
=LARGE(IF(COUNTIF(A$1:A$13,ROW(INDIRECT(MIN(A$1:A$13)&":"&MAX(A$1:A$13)))),ROW(INDIRECT(MIN(A$1:A$13)&":"&MAX(A$1:A$13)))),2)

Third Largest Value:
=LARGE(IF(COUNTIF(A$1:A$13,ROW(INDIRECT(MIN(A$1:A$13)&":"&MAX(A$1:A$13)))),ROW(INDIRECT(MIN(A$1:A$13)&":"&MAX(A$1:A$13)))),3)

Smallest Value:
=SMALL(IF(COUNTIF(C$1:C$10,ROW(INDIRECT(MIN(C$1:C$10)&":"&MAX(C$1:C$10)))),ROW(INDIRECT(MIN(C$1:C$10)&":"&MAX(C$1:C$10)))),1)

Second Smallest Value:
=SMALL(IF(COUNTIF(C$1:C$10,ROW(INDIRECT(MIN(C$1:C$10)&":"&MAX(C$1:C$10)))),ROW(INDIRECT(MIN(C$1:C$10)&":"&MAX(C$1:C$10)))),2)

Let me know if this works for you.

Thanks.