errollflynn
New Member
- Joined
- Jan 25, 2021
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
Hello everyone!
I have an issue I've been banging my head against the wall trying to solve. I have a spreadsheet broken down as follows:
Column A: A dropdown list with multiple recruiters names.
Column B: Manually entered date when a recruiter conducted an interview. A recruiter can only do one interview a day.
Column Q, i.e. the column I'm trying to create: Contains the most recent date a recruiter conducted an interview.
Additional columns that do not have any relevance to what I'm trying to accomplish.
I would like to have a column that would show the most recent date a recruiter conducted an interview. For example, recruiter A may have conducted interviews on 1/1/2021, 1/5/2021, and 1/19/2021. I need to create an expression that will first identify the recruiter's name in column A, then evaluate the dates associated with that recruiter's name in column B, and then return the most recent value in column Q.
This is my first time posting on the boards so please forgive me if I did not approach posing the question correctly.
Thank you in advance.
I have an issue I've been banging my head against the wall trying to solve. I have a spreadsheet broken down as follows:
Column A: A dropdown list with multiple recruiters names.
Column B: Manually entered date when a recruiter conducted an interview. A recruiter can only do one interview a day.
Column Q, i.e. the column I'm trying to create: Contains the most recent date a recruiter conducted an interview.
Additional columns that do not have any relevance to what I'm trying to accomplish.
I would like to have a column that would show the most recent date a recruiter conducted an interview. For example, recruiter A may have conducted interviews on 1/1/2021, 1/5/2021, and 1/19/2021. I need to create an expression that will first identify the recruiter's name in column A, then evaluate the dates associated with that recruiter's name in column B, and then return the most recent value in column Q.
This is my first time posting on the boards so please forgive me if I did not approach posing the question correctly.
Thank you in advance.