Need Urgent: help !!

I have 5 columns and n number of rows. against each row, I need the 2nd max(highest) value by comparing 5 columns' value row wise. it is possible that the value is repeated in columns and may be blank. I am giving an example 

   ApplicationID       Col1     Col1       Col1       Col1      Col1        value should be

      1                        21         25          blank     21          23              23

      2                        96         74          74          74         98              96

Please help I have been trying to get it for the last 24 hrs but have been unable to do it. any help will be appreciated.

PBCommunity