Help

Hi

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.

i.e. 

        1151001

        1151001

        1151001

        1151001

        1151001

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. 

 

                                                      Thank U.

By: MLH

Leave a Reply

Your email address will not be published. Required fields are marked *