![]() ![]() ![]() LARGE($C$5:$C$11,D15), this portion of the formula finds the highest ( D15=1) GPA in range C5:C11.We are selecting cell E15, where we want to see the name of the student who has the highest GPA. Select the cell where you want to put the name of the student.We want to find out the names of the top 3 students with the highest GPAs. Here in this worksheet, we have the names of multiple students, their student IDs, their GPAs ( Grade Point Average), their departments, and their permanent addresses. We can use the LARGE function with the VLOOKUP function to retrieve the associated text data of a numeric value. Method 1: Combining LARGE and VLOOKUP Functions to Get Text Data in Excel We can use the ROWS function along with the LARGE function to get the associated text data of any particular numeric value as well. Moreover, we can also use the LARGE function with INDEX, and MATCHfunctions. We can use the LARGE function with the VLOOKUP function. In this article, we will demonstrate how we can use the LARGE function to get the associated text data of a particular numeric value. Related Articles How to Use Excel Large Function with Text: 3 Easy Ways ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |