In column B I'm looking to find single entry or duplicate entries that have a MIN combined value of 20, (and column D must not be blank). If so enter the MAX date from column C into column F.
Example: Classes named "Class 2" has two entries (in column B), and together they total 20 students (column E), and the type of class taught is filled (in column D). I need the MAX date (column C) entered into column F.
I didn't see the attachment option so I guess I'm supposed to use table (see below)
(Please see original cross-post Link at: https://www.excelforum.com/excel-gen...ml#post4900735Excel Help 4 5-17-18.xlsx
Thank you!
<tbody>
</tbody>
Example: Classes named "Class 2" has two entries (in column B), and together they total 20 students (column E), and the type of class taught is filled (in column D). I need the MAX date (column C) entered into column F.
I didn't see the attachment option so I guess I'm supposed to use table (see below)
(Please see original cross-post Link at: https://www.excelforum.com/excel-gen...ml#post4900735Excel Help 4 5-17-18.xlsx
Thank you!
Class I.D. (column B) | Date of Class (column C) | Type of Class (column D) | Number of Attendees (column E) | Max Date (column F) |
<tbody>
</tbody>