Duplicates, MIN Value, MAX Date

[Barcadro]

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![TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Class I.D. (column B)[/TD]
[TD]Date of Class (column C)[/TD]
[TD]Type of Class (column D) [/TD]
[TD]Number of Attendees (column E) [/TD]
[TD]Max Date (column F)
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Also posted here https://www.excelguru.ca/forums/showthread.php?9011-Duplicates-MIN-Value-MAX-Date

In future please supply links to ALL threads you have started, not just one of them.

 

[Barcadro]

Sorry I didn't include an additional cross-post, adding it here: https://www.excelguru.ca/forums/showthread.php?9011-Duplicates-MIN-Value-MAX-Date&p=37036#post37036