<div>
finding the highest degree is simpel, once you define the order...Excel can only compare when a ranking has been established.<br />
You will probably need a reference table in which you assign a numeric value to sort the degrees.<br />
<br />
Once that is done, a lookup can assign the value to the degree, and a maxif formula can find you the highest degree per person.
</div>


finding the highest degree is simpel, once you define the order...Excel can only compare when a ranking has been established.
You will probably need a reference table in which you assign a numeric value to sort the degrees.

Once that is done, a lookup can assign the value to the degree, and a maxif formula can find you the highest degree per person.

EE-Q_28976451.xlsx

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Let's say column A I have a list of employee names and in column B I have employee education degrees. &nbsp;Since some employees have multiple degrees (Associates, Bachelors, Masters, etc.) there are multiple rows per employee.<br />
<br />
What formula do you recommend that would return the highest degree an employee has earned? &nbsp;For example: &nbsp;A1:A3 read John Doe and B1:B3 reads High School, Associate, Bachelors. &nbsp;The end result I want to see is just the employee name and Bachelors.<br />
<br />
Thanks!
</div>
</div>


Hello,

Let's say column A I have a list of employee names and in column B I have employee education degrees.  Since some employees have multiple degrees (Associates, Bachelors, Masters, etc.) there are multiple rows per employee.

What formula do you recommend that would return the highest degree an employee has earned?  For example:  A1:A3 read John Doe and B1:B3 reads High School, Associate, Bachelors.  The end result I want to see is just the employee name and Bachelors.

Thanks!

Excel 2007 Formula That Pulls Highest Degree From List

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.