-
Scoring data by finding duplicate names.
hello experts,
I am writing to request a macro, which can find duplicate names and score them accordingly, based on the condition below:
Condition:
if name occurs more than 6 times/equal to 6 in sheet1, then place '3', under score in sheet2, else if name occurs more than 3 times /equal to 3 in sheet1, then place '2', under score in sheet2, and else if name duplicate is not found in sheet1, then score the name '1', in sheet2.
score4_example.xls
I have attached example of the data and explained the logic in the above attachment, for further clarification.
Thanks for in advance for any assistance.
-
In cell H3 on Sheet2:
=VLOOKUP(COUNTIF(Sheet1!$A$2:$A$50001,Sheet2!$A3),{0,1;3,2;6,3},2,TRUE)
and copy down.
The 50001 will probably need adjusting to suit.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
-
This is great. Exactly what i was looking for. Many thanks for the amazing help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules