Excel help please

sports_brah

sports_brah

sports_brah

Thug
Soldato
Joined
4 Jan 2013
Posts
3,783
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!
 
[FnG]magnolia;29381538 said:
Can you try explaining it in a different way or give some context?
Click to expand...

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....
 
The description makes it hard to understand what you are trying to achieve (some example data may help clarify) however sounds like something a pivot table may be able to do quite quickly. Use the pivot filters to include/exclude criteria and use the pivot table itself to do the groupings.
 
If I have understood the situation right (which I am not so sure I have), then the below is a quick and easy way.

in Cell C1 (or any other column) put the formula "=A1&B1"
copy this formula down for all rows where there are values
Any duplicates in column C will represent values that are true duplicates.
Use the 'remove duplicates' function and apply it to column C
 
I'll always do something similar to Bill Door's suggestion - I create a new column which has a forumula in to determine whether or not the two columns have met my criteria. If they have I put in "Y" or if they havent, "N". Then I just filter the entire table by that column, so keep all the "Y"s for example. The "" are necessary because Excel doesn't recognise something like =IF(A1=Y,...), it needs A1="Y".
 
You must log in or register to reply here.
Back
Top Bottom