• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Print the highest experienced skill from an alphanumeric string

N Maha

New Member
Hi,
I have an excel file in which a field captures the employee's skill and his experience in months within the brackets. There could be any number of skills as below for example. Now I have to print the top 2 skills by experience in a new column. Can someone suggest a formula for this.

Example : Java spring (14), Java message services (10), Java enterprise (8), C++(6)
 
Top