dannycabrera
New Member
- Joined
- Apr 6, 2018
- Messages
- 5
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)}
<tbody>
</tbody>
Thank you so much!
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)}
SHIP DATE | CUSTOMER | MIN | MAX | 2ND MAX |
1/1/2013 | ABC | 1/1/2013 | 1/3/2013 | 1/2/2013 |
1/2/2013 | ABC | 1/1/2013 | 1/3/2013 | 1/2/2013 |
1/2/2013 | ABC | 1/1/2013 | 1/3/2013 | 1/2/2013 |
1/3/2013 | ABC | 1/1/2013 | 1/3/2013 | 1/2/2013 |
1/3/2013 | ABC | 1/1/2013 | 1/3/2013 | 1/2/2013 |
1/2/2013 | DEF | 1/2/2013 | 1/5/2013 | 1/4/2013 |
1/2/2013 | DEF | |||
1/4/2013 | DEF | |||
1/4/2013 | DEF | |||
1/5/2013 | DEF | |||
1/5/2013 | DEF |
<tbody>
</tbody>
Thank you so much!