Yesterday I am using the excel. My boss gives me a challenging job about excel.
I have a List i.e.
Sr. No Code No. Name Cell No. CNIC No. Adress
In the List I have Code Numbers i.e. 1151001
The list contains 728 codes and all the codes are unique.
There are 5 Names Present in each code.
Like this the next codes .
The Job is that
We mistakenly type 6 or 7 names in each code Now we want to take only 5 names from each code and delete the names above than 5 present in the code.
Manually This Job is about to impossible because the accuracy does not comes by done this job manually.
I hope you understand the situation here.
I just want any formula or any Pre-Designed Macro for the completion of this job.
I Hope You will Help Me as you can and as so as you can.
Problem is submitted for kind consideration Plz.