I need to create a formula that if compared with a date, it can tell me the most recent version of an item. So if I insert 8/12/16 for Item-001, it will return 2.
The dates and items are in no order
<tbody>
Item
Completed Date
Version
Item-001
9/1/16
3
Item-001
6/1/12
1
Item-001
7/1/14...