Copy the most count of identifier and copy them into the selected cells

[geliedee]

Hi All,

I have here a problem. I have two columns, Column A- the identifier and Column B is the customer.


I have to filter the column B to its corresponding customer number. And then the identifier will also be filtered right? Now, i have to get the count of the most identifier ("YES", "NO").

For example:
for customer 2: The max count of identifier is YES then it should replace the other identifier since its the dominant. See below sample picture.

After filtering:
1.JPG

After identifying which is the max count of identifier:
Capture.JPG

As you can see, the NO has been replaced by YES since YES is the has the most count.

Hope you guys can help me.