Most valuable professional
  • Hot Topics

Excel Help for formula to find Top 3 value in excel

Dear Experts, I am facing problem to make summary sheet of top 3 value from large number of value of my excel sheet like- Sheet1 Group 1 2 1 2 3 1 2 3 3 2 1 3 Now I want to make summary in sheet2 top 5 value among the list of sheet1 separately from group 1, 2 & 3. If group number is 1 in sheet1 then top 3 value will be like this- Group1 Name Nashid Jabed Eman If group number is 2 in sheet1 then top 3 value will be like this- Group2 Name

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of April 20, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel