Finding the most recent year in a row for a type of school degree and displaying it in a cell

[ccoulter]

Hello everyone,

What is the best method or combination of methods to go about finding the most recent year for a Bachelor's degree in a row and inserting that year into the column shown below in the example picture? I've already populated the column in my example.

Sometimes the most recent Bachelor's Degree date is before another degree, sometimes it is after another degree. There are three different sets of columns for degrees. This would be used in a report with thousands of rows so I'm trying to find a formula (I think) that could be copied down the column. This most complicated thing I can do in Excel at the moment is a VLookup so I'm just not sure how to proceed with this but I think it could be done by comparing cells and then choosing the highest year, somehow. Any guidance you can offer would be greatly appreciated.

Thank you,

Chris

 

[phoenixdown]

This would be by user right? Is the same user all on the same row or over different rows?

Where are you getting the Years in the boxes you don't have circled in red?

 

[ccoulter]

Hi phoenixdown,

Thanks for your message. Each unique user/person has their own row. The other years and as well as all the data come from a reporting system in that format. I just simplified names for my example.

Thank you for taking a look, I appreciate it.

Chris

 

[ccoulter]

I figured it out a way of doing it using the Max and IF functions. I got the idea from this great post at the Contextures Blog by Deborah Dalgleish.

It may not be the most elegant way but it works.

Thank you all,

Chris