Vlookup with Running Countif
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
