Vlookup with Running Countif

Vlookup with Running Countif

This Concept is used for the data where the Lookup values are not unique in Table Array.

Objective

To make the Lookup column unique using running countif concept and find out the data when required.

Like in below example, Id is not unique, so a New_Id is created using the running countif concept. Refer to the attached sheet for detailed explanation.