2nd Largest Value with Criteria Avoiding Duplicates

[dannycabrera]

I am looking to get the 2nd Largest Value with Criteria Avoiding Duplicates,

essentially I want to find out every customer in my records their min, max and 2nd to max ship date

This was my original take on it, '={LARGE(IF([Column2]=[@Column2],IF([Ship Date]<[@MAX],[Ship Date]),[@MAX]),2)}
[TABLE="width: 500"]
<tbody>[TR]
[TD]SHIP DATE
[/TD]
[TD]CUSTOMER
[/TD]
[TD]MIN
[/TD]
[TD]MAX
[/TD]
[TD]2ND MAX
[/TD]
[/TR]
[TR]
[TD]1/1/2013
[/TD]
[TD]ABC
[/TD]
[TD]1/1/2013
[/TD]
[TD]1/3/2013
[/TD]
[TD]1/2/2013
[/TD]
[/TR]
[TR]
[TD]1/2/2013
[/TD]
[TD]ABC
[/TD]
[TD]1/1/2013
[/TD]
[TD]1/3/2013
[/TD]
[TD]1/2/2013
[/TD]
[/TR]
[TR]
[TD]1/2/2013
[/TD]
[TD]ABC
[/TD]
[TD]1/1/2013
[/TD]
[TD]1/3/2013
[/TD]
[TD]1/2/2013
[/TD]
[/TR]
[TR]
[TD]1/3/2013
[/TD]
[TD]ABC
[/TD]
[TD]1/1/2013
[/TD]
[TD]1/3/2013
[/TD]
[TD]1/2/2013
[/TD]
[/TR]
[TR]
[TD]1/3/2013
[/TD]
[TD]ABC
[/TD]
[TD]1/1/2013
[/TD]
[TD]1/3/2013
[/TD]
[TD]1/2/2013
[/TD]
[/TR]
[TR]
[TD]1/2/2013
[/TD]
[TD]DEF
[/TD]
[TD]1/2/2013
[/TD]
[TD]1/5/2013
[/TD]
[TD]1/4/2013
[/TD]
[/TR]
[TR]
[TD]1/2/2013
[/TD]
[TD]DEF
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/4/2013
[/TD]
[TD]DEF
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/4/2013
[/TD]
[TD]DEF
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/5/2013
[/TD]
[TD]DEF
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/5/2013
[/TD]
[TD]DEF
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thank you so much!

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...rgest-value-criteria-avoiding-duplicates.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).