I need excel formula help

Job ID: 36607772

Budget: ₹100 – ₹400 INR

I need excel formula to find out the recent duplicate value in the Excel which has multiple duplicate values . I need to know the data of the latest / recent duplicate value with the help of formula.

Related categories: Visual Basic Data Processing Data Entry Excel Mathematics