Excel help please

[sports_brah]

Anyone got any idea on how to filter appropriately?


Need to filter results in column a so that it picks up groups of 4 results that are the same, but only if the 4 results in column B are the same.

Around 2000 entries so manual is out of the question.

Thanks!

 

[sports_brah]

I have already a-z column B which are unique entries (specific codes)

Column A are the numbers

 

[sports_brah]

Can you try explaining it in a different way or give some context?

Sorry limited time hence poor description. I'll try better.

I need to be able to remove noise from a report. I need to remove dupes (numbers) but only if they correspond to matching column B.

Otherwise I could remove 4 entries of 200000 but they might be different items.


Forgot to add, the matching items will come in sets of 4....

 

[sports_brah]

Any gurus or is everyone working?