Hi All

I have many rows where there are pairs of certain cells duplicated. I'm
trying to count all rows with the same duplicate entries and put the
total in a separate column. After this the other rows which satisfied
the criteria would be deleted.

So , Count all rows where O1 and M1 are identical . Add the numbers in
L1 and place total in L1. Delete all rows except the first. This should
give a single row which gives a summary total for rows with identical
values in the named cells. Leave unidentical rows unaffected.

Run check through the whole worksheet until complete.

EG

Before :

L O M

2 2567 AA
1 2567 AB
3 2567 AA
1 2567 AA
2 9874 LP
4 6678 CV
2 8887 AB
3 6678 CV
1 8887 AB


After :

L O M

6 2567 AA
1 2567 AB
2 9874 LP
7 6678 CV
3 8887 AB



Grateful for any assistance.



Best Wishes